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

130 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
medalist1141421(None) 
medalists1249371medalists
medallist1246641medallist
metalist10519351metalist
feudalist1356302feudalist
idealist9310652idealist
legalist9512392legalist
mealiest102215972me_aliest
medaling121912262medaling
medallists1344362medallists
medals94218062medal_s_
melanist10313052melanist
mentalist11515552mentalist
metalise10416052metalise
metalists11412662metalists
metallist1159672metallist
midlist10312512mid_list
modelist11310502modelist
moralist10316662moralist
muralist10312982muralist
realist73225382re_alist
sodalist9311882sodalist
aerialist9914263aerialist
alist56136783___alist
annalist8413753annalist
arbalist10313333arbalist
cabalist12314503cabalist
cellist9314423ce_llist
cembalist1547633cembalist
ceramist12310933ceramist
dadaist9310103dada_ist
deadliest1138183deadliest
deadlift1345633deadlift
delist74625053__delist
dialist8517763_dialist
dualist8614053_dualist
enlist6417043_e_nlist
etatist7415033_etatist
fatalist11314973fatalist
federalist1446443federalist
feudalism1554673feudalism
feudalists1454573feudalists
finalist113014733finalist
hedonist1249553hedonist
heraldist1346403heraldist
herbalist1449813herbalist
idealise938053idealise
idealism1147013idealism
idealists1047223idealists
idylist1146653_idylist
kabalist14410083kabalist
legalise949493legalise
legalism1148583legalism
legalists1047943legalists
localist101613963localist
loyalist111511133loyalist
maist75535683m__a_ist
mealie82519813me_ali_e
mealier93015903me_alier
mealies92821933me_alies
meals75933383me_al_s_
meanest9315703me_anest
measliest1147173measliest
meatiest102816793me_atiest
mechanist1648743mechanist
medakas1435763medakas_
medal86221333medal___
medaled113411613medal_ed
medalled1246893medalled
medallic1345113medallic
medalling1346923medalling
medallion1244073medallion
meddles113213253meddles_
meddling13257933meddling
medflies1435553medflies
medials103914743medial_s_
medievalist1752893medievalist
medlars10259443medlars_
megabit12117963megabi_t
megabits1355793megabits
megahit1378773megahi_t
megahits1445683megahits
megalith1448243megalith
melanism1239363melanism
melanists1148623melanists
melodist1149743melodist
mentalism13511643mentalism
mentalists12410483mentalists
metaling111613723metaling
metalised12310463metalised
metalises11315073metalises
metalize19414783metalize
metallists1266713metallists
metals84520893metal_s_
metrist9317063me_trist
midlists1137523mid_lists
modality14117653modality
modals93914463modal_s_
modelists1246473modelists
moralise10314913moralise
moralism12312363moralism
moralists11311103moralists
muralists1148163muralists
mutualist1146403mutualist
odalisk1265373_odalisk
oralist7619633_oralist
pedalier1137603pedalier
pedaling122412133pedaling
pedalos10329703pedalos_
pedals94316033pedal_s_
penalise101013763penalise
realest73322433re_alest
realise73021813re_alise
realism93115923re_alism
realists83014843re_alists
reenlist8410363reenlist
relist64628413re__list
royalist111311983royalist
ruralist8311703ruralist
sealift10312793se_alift
sedatest9249393sedatest
serialist9715113serialist
sodalists1038153sodalists
totalist8315583totalist
vealiest112513203ve_aliest
vedalia1145683vedali_a
vedalias1245153vedalias
verbalist1449503verbalist
vitalist11313393vitalist
vocalist131512123vocalist

Search took 9 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 Limit1461621307.72018932.9
3Display Results1301300.0632063.5
 (SQL Overall)1786911308.20321783.6
 
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.