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 “distill” 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.

156 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
distill8301132(None) 
distil73616431disti_l
distills9319041distills
distils83015801distils
dirtily1138582dirtily
distal73615772dist_al
distally1239552distally
distich13312172distich
distilled1147182distilled
distiller1046672distiller
dustily113211532dustily
instill789062instill
misbill1137032misbill
mistily122612342mistily
pistil83915072pisti_l
pistils93314302pistils
redistill1044502redistill
still54922082__still
bastile9313913bastile
bastille1048003bastille
bestial9311643bestial
daintily1245523daintily
deistic10311173deisti_c
deistical1246673deistical
dentil74017883denti_l
dentils84115583dentils
destine83719953destine
destiny113111463destiny
diastole947563diastole
diastral946993diastral
dictier103411863dictier
diction102313053diction
dieting93616833dieting
digital937063digital
dill55239973d___ill
dingily1238103dingily
dinting93520553dinting
dipstick1775223dipstick
dirtied93210853dirtied
dirtier83312093dirtier
dirties83119383dirties
disable10516433disable
disci85815023disci__
discing113914593discing
disciple1346673disciple
dishelm1335833dishelm
dishful1455433dishful
dishier113613403dishier
dishing124017103dishing
disking134615493disking
dislike122913453dislike
dislimn1056103dislimn
dismal92412243dis_mal
dismally1446513dismally
dismals102010243dismals
dismiss1038153dismiss
dispel9310323dis_pel
dispels10310503dispels
dissing94517683dissing
distaff1467683distaff
distain8313783distain
distains9413603distains
distant83519953distant
distend93312073distend
distent84120853distent
distichal1544833distichal
distichs1447633distichs
distillate1146743distillate
distillers1145133distillers
distillery1443153distillery
distilling1247793distilling
distinct11410763distinct
distome10313233distome
distort81120333distort
district11413873district
disturb1046233disturb
dithiol1145433dithiol
ditsier83010293ditsier
ditties83116983ditties
dizzily1934843dizzily
dossil75110903dossi_l
dossils8669773dossils
dottily1147283dottily
drill64718263d__rill
ductile1048483ductile
duskily15236753duskily
dustier83814133dustier
dusting93618993dusting
feistily1445263feistily
fictile1238023fictile
fishily1637643fishily
fishkill1842143fishkill
fissile10269653fissile
fistful1365903fistful
fistic11812573fisti_c
fisting113818123fisting
fistula1045503fistula
fustily133111383fustily
gristmill1261703gristmill
gustily113010903gustily
hastily133010663hastily
histing113720373histing
hostile10312553hostile
infill938413_infill
install779363install
instil61111383insti_l
instills867353instills
instils7811453instils
istle52214713_ist_le
kistful1465303kistful
listel64214743list_el
listels74212433listels
listing84020593listing
lustily103611243lustily
misbills1246083misbills
miscall1139653miscall
misdial1039643misdial
misfile122611553misfile
missile92815403missile
mistier93418713mistier
mistime11312613mistime
misting103623383misting
mistitle1038523mistitle
mistral91013643mistral
mistrial10311383mistrial
mustily123613633mustily
nastily103011033nastily
niftily1335753niftily
pastil85018323pasti_l
pastille1038943pastille
pastils94416173pastils
pistol83313333pist_ol
pistole92414313pistole
pistols93213983pistols
redistills1143163redistills
riskily1436413riskily
rustily103112993rustily
shill85325333__shill
sill45545153__s_ill
skill94316723__skill
spill74821163__spill
stall54722353__stall
stile54931573__stile
stills64118573__stills
stilly93714093__stilly
stilt54831983__stilt
stull54916273__stull
swill83417373__swill
tastily103311643tastily
testily102910803testily
till45941203___till
wispily1535653wispily
wistful1365713wistful
wisting113519743wisting
wittily1336173wittily
zestily19167563zestily

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 Filter1786911340270.393454684.5
2DLD Change Limit1340271567.50017870.3
3Display Results1561560.0602600.0
 (SQL Overall)1786911567.95322468.4
 
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.