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 “sumos” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

126 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
sumos7572009(None) 
sumo67326311sumo_
sumps95023431sumps
sums65837581sum_s
ammos94815822ammos
autos56523322autos
bumfs125414052bumfs
bumps115921142bumps
bums85934592bum_s
camos95927612camos
demos86022992demos
dumas85420432dumas
dumbos114111082dumbos
dumbs105915752dumbs
dumps105220102dumps
duomos936822duomos
duos56728132du_os
duros65422692duros
euros54920242euros
fumes105224702fumes
gumbos114610872gumbos
gums75030942gum_s
homos105921792homos
humor101110512humor
humors11129632humors
humps126322802humps
hums96831422hum_s
humus106215072humus
jucos144111712jucos
judos134711732judos
jumbos17379122jumbos
jumps165116492jumps
kudos105011252kudos
kumys1435932kumys
limos75320812limos
lumas75622912lumas
lumps95624982lumps
lums65734242lum_s
memos95719112memos
mos57067122__mos
mumms85513152mumms
mumps115619102mumps
mums85732772mum_s
mumus95517282mumus
nomos75919742nomos
numbs94913092numbs
ouzos143210412ouzos
pomos95321582pomos
pumas95121562pumas
pumps115520602pumps
rumor71011322rumor
rumors81110402rumors
rumps95922292rumps
rums64833472rum_s
sagos66123872sagos
sambos104315192sambos
samosa8510202samosa
samps96124672samps
saros55238062saros
schmos13379152schmos
scums95017422scum_s
segos64919482segos
semes75731582semes
semis74623532semis
shamos114216982shamos
shmo95318102shmo_
shmoes114612102shmoes
shoos84226362shoos
silos56029432silos
simas75727552simas
simps94719762simps
sims65737172sim_s
sixmos1534812sixmos
skimos12548802skimos
slumps104313582slumps
slums74623432slum_s
smog76317412s_mog
smogs85112162s_mogs
smuts75415712smuts
solos54830792solos
somas76030372somas
soms66239372som_s
sos37761602s__os
spumes1021314882spumes
spumous1135852spumous
stumps104912282stumps
stums75320082stum_s
subas74724072subas
subs66037122su_bs
sucks114523072sucks
sudds75513592sudds
sudor6312622sudor
sudors7311102sudors
suds56135292su_ds
suers55128482suers
sues46247652su_es
suets55126102suets
sughs95313322sughs
suits55028052suits
suks85927122su_ks
sulks94818462sulks
sulus54821882sulus
sum56346012sum__
sumac99514882sumac
sumacs105512102sumacs
summa94713312summa
summas104313162summas
summon1037622summon
summons1158002summons
sumoist9311612sumoist
sump86331532sum_p
sunns55017352sunns
suns45841902su_ns
supes75628302supes
sups64834432su_ps
suqs134319652su_qs
suras55336332suras
surds65624662surds
surfs85022542surfs
suss45229302su_ss
tumor71110692tumor
tumors8810612tumors
tumps95420792tumps
udos56619902_udos
umbos94613072_umbos
umps85721942_umps

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001261.59333772.8
3Display Results1261260.0333818.2
 (SQL Overall)1786911261.93992156.3
 
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.