Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “despoils” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
despoils114562(None) 
despoil1046521despoil_
desmoids1244972desmoids
despairs1144942despairs
despoiled1344652despoiled
despoiler1243962despoiler
despoilers1343532despoilers
desponds1246242desponds
despots10319682despo_ts
respools1036252respools
spoils84614532__spoils
assoils776663_assoils
cesspools1342103cesspools
cestoids11308283cestoids
deils65722863de___ils
deltoids1045483deltoids
dentils84115583de_ntils
depolish1446943de_polish
depones103717093de_pones
deports105012883de_ports
deposals1145443de_posals
deposes103117213de_poses
deposits1138843de_posits
depots94716343de_po_ts
derails84216393de_rails
dermoids1246163dermoids
descries11311923descries
desmids1166603des_mids
desmoid1137103desmoi_d
desorbs10437713des_orbs
despair1045463despai_r
despisals1243503despisals
despise1038683desp_ise
despises1139433despises
despite10410123desp_ite
despites11410313despites
despoiling1445113despoiling
despond1137513despo_nd
despot93413293despo__t
despotic1346533despotic
despotism1444043despotism
despotisms1543153despotisms
destains9311813destains
details84214043de_tails
devils104412813de__vils
devoirs1175783de_voirs
dewools1145593de_wools
discoids1239873discoids
disjoins1647623disjoins
dispels10310503disp_els
disports111111113disports
disposals1245893disposals
disposes11313823disposes
distils83015803dis_tils
dossils8669773dos_sils
entoils7810733_entoils
espials937093_espials
espies83716803_esp_ies
esprits938393_esprits
essoins737603_essoins
jetfoils1842453jetfoils
reboils94111723re_boils
recoils93814873re_coils
redpolls1144013redpolls
reoils64516873re__oils
repolls939053re_polls
resails74616743res_ails
respells1056333respells
resplits1037723resplits
responds1136913responds
respool937643respool_
respots92912763respo_ts
sesspools1142393sesspools
soils55327983__s_oils
spails84817823__spails
speils84116223__speils
spoil75818653__spoil_
spoilt85016593__spoilt
spools85115913__spools
topsoils1095143topsoils
unspoilt1044883unspoilt
unspools1043693unspools
vespids1334613vesp_ids

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.420425454.8
2DLD Change Limit146162837.51619446.8
3Display Results83830.0302766.7
 (SQL Overall)178691837.96622431.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.