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

154 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
muesli83518(None) 
mueslis935491mueslis
duelli767002duelli
muslin8312212mu_slin
ceili75814793_ceili
celli76717693_celli
cesti75217423_cesti
cues65438983cues__
cuesta838513cuesta
cumuli1036273cumuli
deli55631293_de_li
duel56729703due_l_
duello756783duello
duels65619233due_ls
dues56045503dues__
fuel76824733fue_l_
fuels87117353fue_ls
fumuli1135263fumuli
fusel85218493fusel_
fusels94412453fusels
fusil84715323fu_sil
guess64213363gues_s
guest65225923gues_t
guests74311203guests
hues75235233hues__
kues86426773kues__
lues45943553lues__
maes66948393maes__
maestri945473maestri
meal65643173m_eal_
mealie82519803m_ealie
meals75933373m_eals
mealy104422183m_ealy
measle83513223measle
measly113610443measly
medii84513493m_edii
meekly1535193meekly
meetly1138673meetly
mel56047483m_e_l_
meld75830473m_e_ld
melic94722333m_e_lic
mell64935613m_e_ll
mells75031333m_ells
mels65941533m_e_ls
melt65752893m_e_lt
merl65830973m_erl_
merle75824373m_erle
merlin83916683m_erlin
merls77423903m_erls
mesa67025483m_es_a
mesas76823203m_esas
mesh96823003m_es_h
meshy135612783m_eshy
mesic93617863m_esic
mesne75116293m_esne
meson74118313m_eson
mess65932433m_es_s
messy104913833m_essy
mewl95618323m_ewl_
mewls105813233m_ewls
mislie83219153m_islie
mislit83019693m_islit
moduli9267943moduli
moues75732843moues__
muchly1686203muchly
muckle143413583muckle
muddle103414633muddle
muddly13418603muddly
muds75530653muds__
mudsill1045163mudsill
mudslide1243573mudslide
mueddin1143423mueddin
muezzin1742703muezzin
muffle14339643muffle
mufti10610543mu_fti
mugs76232043mugs__
muhly1358523mu_hly
mule65236973mu__le
mules75034293mules__
mull65128803mu__ll
mulla74317113mu_lla
mulls75124153mu_lls
mumble123614343mumble
mumbly15319463mumbly
mums85732773mums__
muni65824403mu__ni
muns65535913muns__
mural75225103mural_
murals84016753murals
mures75937213mures__
murkly15368303murkly
mus55946753mu_s__
musca9311763mu_sca
muscid11219833mu_scid
muscle10310973muscle
muscly1337453muscly
muse67136033mu_s_e
mused85524583mu_sed
muser76024123mu_ser
musers84719093musers
muses75134303mu_ses
museum1037703museum
mush94929123mu_s_h
mushy135316633mu_shy
music94316403mu_sic
musjid16216953mu_sjid
musk104526193mu_s_k
muskie123412533mu_skie
muskit122813253mu_skit
musks116119643mu_sks
musky144715293mu_sky
muslins9312213mu_slins
muss64933763mu_s_s
mussed94418903mussed
mussel83412903mussel
mussels9419843mussels
musses84624783musses
mussily12279773mussily
mussy104117643mu_ssy
must65145443mu_s_t
musth105314783mu_sth
musts75527443mu_sts
musty105620953mu_sty
mutedly1345753mutedly
mutely113811653mutely
mutes75033783mutes__
mutest84218053mutes_t
muts64839983muts__
mutule8311423mutule
muzzle16319393muzzle
myelin1138963mye_lin
myself1445593myself
nielli636303nielli
nucelli944723nucelli
obeli73711933obe_li
ocelli836843ocelli
ousel55222403ousel_
ousels64815273ousels
pueblo1035553pueblo
puli65527623pu__li
pussly11407373pussly
quasi144015023quas_i
quell144311423que_ll
quells15359693quells
quest144121323ques_t
quests153310353quests
rues46044483rues__
sues46247653sues__
sushi8310493su_shi
suslik1036373su_slik
tesla55612603_tesla
tufoli933973tufoli
tumuli835933tumuli
tussle637143tussle

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161546.43617513.4
3Display Results1541540.0463347.8
 (SQL Overall)1786911546.62226984.4
 
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.