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

172 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
mutts7512025(None) 
butts75824251butts
matts76829181matts
mitts75523751mitts
motts76527001motts
musts75527441musts
mutes75033781mutes
muts64839981mu_ts
mutt65739401mutt_
putts75719271putts
aunts55227632aunts
autos56523322autos
batts76727562batts
bitts75022592bitts
botts75224862botts
bunts75729802bunts
busts75227692busts
butes714535872butes
buts67247692bu_ts
butt65143742butt_
butte74924292butte
buttes84822562buttes
butty104020112butty
bututs8409422bututs
cults75022552cults
cunts76125122cunts
cutes79438312cutes
cutis77723752cutis
cuts65841152cu_ts
cutty105417222cutty
ducts85319892ducts
duets65323882duets
duits65021882duits
dunts65828412dunts
dusts65923562dusts
gusts65722792gusts
guts56637252gu_ts
gutta64613382gutta
gutty94516992gutty
hunts86826172hunts
hurts86922822hurts
huts76737442hu_ts
justs124918262justs
jutes125125132jutes
juts115930162ju_ts
jutty154914642jutty
lunts55826902lunts
lusts55022802lusts
lutes55836662lutes
malts76331752malts
marts77442232marts
masts77035762masts
mates75251362mates
maths105624022maths
mats65460282m_ats
matt65752652matt_
matte75626842matte
mattes85624532mattes
mauts75927192mauts
meats75034052meats
meets74224612meets
melts74930102melts
metes74736212metes
meths105320232meths
metis75025902metis
milts75430712milts
mints76834042mints
mists76633902mists
mites75141802mites
mitis75425982mitis
mitt66145482mitt_
moats75827642moats
molts76032092molts
moots75831662moots
morts75533562morts
mosts76028542mosts
motes75944002motes
motets84216192motets
moths106021552moths
mots66853162m_ots
mott66648442mott_
motte75526972motte
mottes85523692mottes
motto76119512motto
mottos84615242mottos
moults84713702moults
mounts84115072mounts
mouths115214532mouths
mucks134622642mucks
mucus94015742mucus
muds75530652mu_ds
muffs134114212muffs
mufti10610542mufti
muftis1158052muftis
muggs94912322muggs
mugs76232042mu_gs
mulcts10298712mulcts
mules75034292mules
mulls75124152mulls
mumms85513152mumms
mumps115619102mumps
mums85732772mu_ms
mumus95517282mumus
munis75022002munis
muns65535912mu_ns
muons75816172muons
muras75329562muras
mures75937212mures
murks114821722murks
murrs75521292murrs
mus55946752mu__s
muses75134302muses
musks116119642musks
muss64933762mu_ss
must65145442must_
musth105314782musth
musths11589482musths
musty105620952musty
mut58357182mu_t_
mutants938582mutants
mutase82811982mutase
mutate83017482mutate
mutates92215792mutates
mutch125016172mutch
mute65136872mu_te
muted85023382muted
muter74525542muter
mutest84218052mutest
mutism103211462mutism
muton73817002muton
mutons84314362mutons
mutter84418882mutter
mutters94117132mutters
mutton8510452mutton
muttons949282muttons
myths135911602myths
netts55320722netts
nuts45032672nu_ts
nutty84816872nutty
ousts55225702ousts
outs45746962ou_ts
punts75828002punts
puts65641752pu_ts
putt66937842putt_
putti76018742putti
putto75617662putto
putty104721402putty
quits144122352quits
runts55927632runts
rusts55026992rusts
ruths85714642ruths
ruts44541492ru_ts
rutty85617802rutty
setts55124322setts
smuts75415712smu_ts
smutty11266322smutty
suets55126102suets
suits55028052suits
sutta54015332sutta
suttas63813792suttas
tufts85713272tufts
tuts45838452tu_ts
tutti54614672tutti
tuttis63611372tuttis
tutty85217022tutty
tutus55214812tutus
utas45924952_utas
utes45930882_utes
uts35534372_u_ts
watts86923092watts
yetts86715132yetts
yurts87216532yurts

Search took 5 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.1731032896.0
2DLD Change Limit538001723.71614477.9
3Display Results1721720.1401228.6
 (SQL Overall)1786911724.02944351.2
 
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.