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 “handlist” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
handlist1231133(None) 
handlists1347131handlists
handfast1546732handfast
handiest123417782handiest
handles114020652handles_
handless123512062handless
handlike1639152handlike
handling132312712handling
panelist10414502panelist
alist56136783_a__list
analyst10189323_analyst
animist93815173_animist
annalist8413753annalist
backlist16910653backlist
bandit93821133band_i_t
bandits103814793band_its
banjoist1745143banjoist
bundist10310193bund_ist
cabalist12314503cabalist
canalise10816213canalise
candles104422343candles_
candling122313873candling
canoeist10310693canoeist
canonist10513533canonist
dadaist9310103da_daist
dandiest103415033dandiest
dandles94218533dandles_
dandling112511733dandling
dandyish1644723dandyish
dandyism1543943dandyism
dangliest1137173dangliest
enlist6417043_en_list
fabulist1347673fabulist
faddist12289643fa_ddist
fatalist11314973fatalist
finalist113014733finalist
gangliest1137673gangliest
hackliest1836523hackliest
haddest122711993ha_ddest
hadjis17439653ha_djis_
hadst93220223ha_d__st
hagadist1347603hagadist
halakist15158223halakist
halest94823273ha__lest
handbill14115163handbill
handcart1449323handcart
handclasp1742863handclasp
handers114224333handers_
handfasts1644593handfasts
handier113817443hand_ier
handily143610873hand_ily
handing123518893hand_ing
handle104219293handl__e
handled124114533handl_ed
handler113516163handl_er
handlers124014143handlers
handlings14237343handlings
handloom1444613handloom
handout11314103hand_out
handouts1238233handouts
handpick2043843handpick
handprint1546983handprint
hands95327383hand__s_
handset113016823hand_set
handsets12258343handsets
handwrit1547243handwrit
hangnest12311413hangnest
hantles104117513hantles_
hardest113118413hard_est
hardiest123416343hardiest
hardline12310273hardline
harpist12312363ha_rpist
hindmost1444483hindmost
holist94723213h__olist
homilist13410033homilist
hondles113614523hondles_
hondling132210013hondling
jangliest1746383jangliest
kabalist14410083kabalist
kindliest1436113kindliest
landless94011173landless
landline9311443landline
manliest102314943man_liest
midlist10312513_midlist
pandit93820753pand_i_t
pandits103914213pand_its
panelists1148343panelists
phallist1338993pha_llist
randiest93418773randiest
sadist74221353sa_d_ist
sandblast1255653sandblast
sandfish1556683sandfish
sandhis1139993sandhis_
sandiest93218693sandiest
sandless93212343sandless
sandlike1339713sandlike
sandling102214413sandling
sandlot8311693sandl_ot
sandlots938293sandlots
sandpit1049633sandpi_t
sandpits1146843sandpits
tangliest1068423tangliest
tanist6324593tan__ist
vandalise1347673vandalise
vandalish1645993vandalish
vandalism1546873vandalism
waitlist1147743waitlist

Search took 7 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.406440125.6
2DLD Change Limit1461621076.53322372.9
3Display Results1071070.0462326.1
 (SQL Overall)1786911076.98525582.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.