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

127 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
midlists113752(None) 
midlist10312511midlist_
biblists1236872biblists
dialists9411412dialists
fideists1245542fideists
idylists1244122_idylists
medalists1249372medalists
midlines112613332midlines
midlives14287462midlives
midmosts1343772midmosts
midsts95510052mid__sts
modelists1246472modelists
titlists837292titlists
violists1137662violists
aidless83612073aidles_s
airlifts1143633airlifts
biblist11310833biblist_
cellists1038563cellists
cyclists1545713cyclists
dadaists1045583dadaists
deists74916433__deists
delists84414173_delists
dialist8517763dialist_
diallists1056003diallists
diarists9410363diarists
dualists958243dualists
duelists966003duelists
enlists749393_enlists
faddists13235543faddists
fideisms1444453fideisms
fideist1139753fideist_
fidelista1343203fidelista
fidelistas1451873fidelistas
finalists123010163finalists
handlists1347133handlists
holists104413963_holists
homilists1456813homi_lists
idealists1047223_idealists
idiots768643_id_iots
idlest74014863_idlest_
idolises938763_idolises
idolisms1146353_idolisms
idylist1146653_idylist_
idyllists1342443_idyllists
imagists1175113imagists
insists739083_insists
judoists1643653judoists
libelists1146953libelists
lidless8309273lidles_s
lists56628693___lists
maists85817573m__aists
medalist11414213medalist_
medallists1344363medallists
metalists11412663metalists
metrists1039853metrists
midairs1037203midai_rs
midcults1343223midcults
middies113116153middi_es
middlings14194313middlings
midgets113910253mid_gets
midguts11296013mid_guts
midis85923413mid_i__s
midlands1245543midlands
midlegs1156323midl_egs
midlife13248303midli_fe
midlifer14215793midlifer
midlifers15254933midlifers
midline102315103midli_ne
midmost1246153midmost_
midnights1642683midnights
midpoints14103803midpoints
midribs1235513midri_bs
midriffs1742533midriffs
midst85922553mid__st_
midwifes17234713midwifes
midwives17274803midwives
mildest102812063mildest_
milieus939803mi_lieus
millets94216843mi_llets
milliers102611903milliers
millimes122411373millimes
millines102718063millines
millings113712583millings
millions101712433millions
milts75430713mi_l__ts
mindless11319443mindles_s
miscasts1238353miscasts
misfits12279663misfi_ts
mishits122513083mishi_ts
mislies92922283misli_es
mislights1544663mislights
mislikes143311833mislikes
mislit83019693misli_t_
mislives132912153mislives
missises103513693missises
mists76633903m___ists
mitises9315543mi_tises
modelist11310503modelist_
modiste1039283mod_iste
modistes1138643mod_istes
molests93311563m_olests
monists93614783m_onists
moralists11311103moralists
muralists1148163muralists
niellists944793niellists
nihilists1244853nihilists
nudists8356833nud_ists
oculists1037133oculists
odists749853_od_ists
oralists8611803oralists
pianists1049013pianists
pietists1038323pietists
pollists10910823pollists
realists83014843realists
relists73817053_relists
sadists83310853sad_ists
sciolists1147213sciolists
shitlists1245533shitlists
simplists13266503simplists
sodalists1038153sodalists
stylists11207023stylists
tidbits1035183tidbi_ts
titlist7312923titlist_
vibists1256483vi_bists
violist10312143violist_
vitalists1239223vitalists
waitlists1244603waitlists

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.423422437.4
2DLD Change Limit1461621277.12320519.7
3Display Results1271270.0502540.0
 (SQL Overall)1786911277.59623524.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.