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

210 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
midlist1031251(None) 
midlists1137521midlists
biblist11310832biblist
dialist8517762dialist
fideist1139752fideist
idlest74014862_idlest
idylist1146652_idylist
medalist11414212medalist
midis85923412mid_is_
midlife13248302midlife
midline102315102midline
midmost1246152midmost
midst85922552mid__st
mildest102812062mildest
mislit83019692misli_t
modelist11310502modelist
titlist7312922titlist
violist10312142violist
aidless83612073aidless
aiolis6316843aiolis_
airlift1048583airlift
alist56136783__alist
amidst94913233amid__st
bialis83617163bialis_
biblists1236873biblists
bidis86721143bid_is_
cellist9314423cellist
cyclist1438853cyclist
dadaist9310103dadaist
deist64633593__deist
delist74625053_delist
dialists9411413dialists
diallist949553diallist
diarist8517113diarist
didst74619613did__st
dualist8614053dualist
duelist8511413duelist
enlist6417043_enlist
faddist12289643faddist
fideism1335773fideism
fideists1245543fideists
fidelista1343203fidelista
finalist113014733finalist
giddiest11298553giddiest
girliest93010403girliest
girlish1137193girlish
godliest1039453godliest
handlist12311333handlist
hilliest113914113hilliest
holist94723213_holist
homilist13410033homi_list
idealist9310653_idealist
idiot6718863_id_iot
idles66720123_idles_
idling8912883_idling
idolise839293_idolise
idolism1037273_idolism
idylists1244123_idylists
idyllist1243963_idyllist
illest63615723_illest
imagist1077333imagist
insist6314513_insist
judoist1545633judoist
kiddish16276583kiddish
kidlike1137063kidlike
kindliest1436113kindliest
libelist10310823libelist
lidless8309273lidless
list47055343___list
maddest112311213maddest
maddish14289483maddish
maidish13239553maid_ish
maist75535683m__aist
manliest102314943manliest
marliest102415183marliest
mealiest102215973mealiest
medalists1249373medalists
medallist1246643medallist
metalist10519353metalist
metrist9317063metrist
micklest16219123micklest
midair937993midai_r
midairs1037203midairs
midcult1246303midcult
middies113116153middies
middles113415303middles_
middling13249343middling
midges103516473midges_
midget103718443mid_get
midgets113910253midgets
midgut103510053mid_gut
midguts11296013midguts
midi75628473mid_i__
midland1136613midland
midleg1038553midl_eg
midlegs1156323midlegs
midlifer14215793midlifer
midlines112613333midlines
midlives14287463midlives
midmosts1343773midmosts
midnight1544493midnight
midpoint13117493midpoint
midrash1335423midrash
midrib1138243midri_b
midribs1235513midribs
midriff1645513midriff
mids76541783mid__s_
midsize1946393midsize
midsts95510053mid__sts
midwife16225523midwife
miffiest1637123miffiest
milding113615453milding
milds86422053mi_lds_
miles74645073mi_les_
milia72719573mi_li_a
milieu8314113mi_lieu
milium104712683mi_lium
milkiest142911083milkiest
milks115020583mi_lks_
milles84526563milles_
millet84030743mi_llet
millets94216843millets
millier93716703millier
millime112511403millime
milline92519113milline
milling103223683milling
million91813143million
mills75435053mi_lls_
milos75428013mi_los_
mils66045333mi_l_s_
milt65455813mi_l__t
miltiest103015173miltiest
milts75430713mi_lts_
minciest122913103minciest
mindless11319443mindless
mingiest113315813mingiest
minis75432993mi_nis_
minish115216303mi_nish
mintiest103217143mintiest
minxish1936213minxish
miosis83615163miosis_
miriest93619823miriest
mirkest13309723mirkest
mirkiest142910253mirkiest
miscast11312413miscast
misfit112813833misfi_t
misfits12279663misfits
mishit112618193mishi_t
mishits122513083mishits
mislie83219153misli_e
mislies92922283mislies
mislight1447243mislight
mislike132914833mislike
mislive122812693mislive
missis84417503missis_
mist66154533m___ist
mistiest103018313mistiest
mitiest93520053mitiest
mitis75425993mi_tis_
modelists1246473modelists
modest93818453mod_est
modish123813543mod_ish
modiste1039283mod_iste
moist76033583m__oist
moldiest11249693moldiest
molest85022743m_olest
monist84324983m_onist
moralist10316663moralist
motliest10310773motliest
muddiest12298733muddiest
mudfish1646263mudfish
mulish11311903m_ulish
muralist10312983muralist
niellist848353niellist
nihilist1147163nihilist
nudist73813323nud_ist
oculist9310883oculist
odist6421913_od_ist
oiliest72817683oi_liest
oralist7619633oralist
pianist9615103pianist
pietist9414033pietist
pilis75825203pi_lis_
pollist9816603pollist
realist73225383realist
relist64628413_relist
ridgiest1038903ridgiest
sadist74221353sad_ist
sciolist10410233sciolist
shitlist1148713shitlist
sidles74721153sidles_
sidling9915423sidling
silliest84017093silliest
simplist12249683simplist
sodalist9311883sodalist
stylist102110283stylist
tidbit938493tidbi_t
tidbits1035183tidbits
tidiest83514873tidiest
titlists837293titlists
vibist11610583vi_bist
vilest9416843vi_lest
violists1137663violists
vitalist11313393vitalist
waitlist1147743waitlist
widest104517003wid_est
widish13419363wid_ish
wildest113311273wildest
wildish1446853wildish
wiliest103416593wi_liest

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 Filter1786911340270.203880251.2
2DLD Change Limit1340272107.87317023.6
3Display Results2102100.0962187.5
 (SQL Overall)1786912108.17221866.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.