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

149 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
sumoist931161(None) 
sumoists1046731sumoists
humorist1348782humorist
judoist1545632judoist
moist76033582__moist
simonist10410722simonist
soloist7915892soloist
subsist9311572subsist
summit10311542summi_t
summits1137982summits
sumos75720092sumo_s_
almost81014433almo_st
altoist7313393altoist
amorist9317643_amorist
atomist92915763atomist
aurist65027253au_rist
autist64324943au_tist
bemist105216953bem_ist
bummest13298623bummest
bumpiest1437873bumpiest
bundist10310193bundist
cambist13312113cambist
cubist104214443cu_bist
cultist91412713cultist
demonist11413463demonist
demotist11311843demotist
dualist8614053dualist
duelist8511413duelist
dumbest1238743dumbest
dumpiest1338743dumpiest
dumpish15116113dumpish
egoist7612283_egoist
eulogist949043eulogist
foist85730973__foist
fuguist1136073fuguist
fumiest12312193fumiest
gnomist1049133gnomist
gummiest13269023gummiest
hoist86433213__hoist
humanist13410493humanist
humorists1445783humorists
humors11129633humors_
humpiest1538963humpiest
hymnist1546633hymnist
inmost8411363inmo_st
joist125125653__joist
judoists1643653judoists
jujuist1343073jujuist
jumpiest1936863jumpiest
jurist134616393ju_rist
kumiss1235923kum_iss
luminist10410563luminist
lumpiest1239253lumpiest
lumpish14127383lumpish
lutist64317553lu_tist
maist75535683__maist
mist66154533__m_ist
monist84324983__monist
most66554203__mo_st
nudist73813323nu_dist
numbest1138793numbest
oboist8312683_oboist
outmost9511213outmo_st
poloist91016323poloist
purist85525053pu_rist
querist16311133querist
quoit143819863qu_oi_t
quoits15379683qu_oits
rummest11279833rummest
rummiest12299353rummiest
rumors81110403rumors_
sacrist9315423sacrist
sadist74221353s_adist
samosa8510203samo_sa
sarodist9510923sarodist
schist11312653s_chist
sciolist10410233sciolist
scummiest1535213scummiest
semimoist1345613semimoist
semis74623533sem_is_
semitist10413323semitist
sexist133013483s_exist
shamois123210423shamois_
shist84829613s__hist
shmoes114612103shmoes_
simonists1146763simonists
simplist12249683simplist
slumism1136513slum_ism
slummiest1335663slummiest
smit65138413s_m_i_t
smogs85112163s_mogs_
smokiest1437883s_mokiest
smolt74824163s_mo_lt
smolts84411883s_molts
smoosh11236733s_moosh
sodomist1157633sodomist
soloists869153soloists
sophist12311563sophist
spoilt85016593s_poilt
spumiest1238203spumiest
spumonis1264113spumonis_
spumous1135853spumous_
statist7317723statist
stumpiest1335853stumpiest
stylist102110283stylist
suavest10310623suavest
submiss1138083submiss
submit10312673submi_t
submits1139753submits
subsists1037993subsists
subtest9513963subtest
suckiest143314113suckiest
sudors7311103sudors_
sudsiest939623sudsiest
suggest9310863suggest
suint55638183su__int
suit45649873su__i_t
suits55028053su__its
sulkiest124212503sulkiest
sumacs105512103sumacs_
sumless92611123sumless
summarist13116763summarist
summas104313163summas_
summing122912383summing
summons1158003summons_
sumo67326313sumo___
sumps95023433sum_ps_
sums65837583sum__s_
sunfast1038503sunfast
sunfish1338883sunfish
sunlit61516103sunli_t
sunniest82712913sunniest
sunrise7310813sunrise
sunwise1036433sunwise
surest65026763su_rest
surfiest112414433surfiest
surliest82416913surliest
surmise9311083surmise
surmount1045903surmount
sushis9311183sushis_
symbiot1465273symbiot
symbolist1675953symbolist
tubaist938703tubaist
tubist83013163tu_bist
tumors8810613tumors_
upmost1068193upmo_st
utmost878483utmo_st
utopist938693_utopist
yummiest15256723yummiest

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271496.78019768.0
3Display Results1491490.0632365.1
 (SQL Overall)1786911496.98325589.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.