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

166 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
smuts7541571(None) 
muts64839981_muts
scuts74522521scuts
shuts85622481shuts
sluts54523981sluts
smut66629781smut_
abuts75417072abuts
amus65529612amu_s
besmuts1134682besmuts
bhuts105812952bhuts
bouts75131312bouts
bruts75922952bruts
buts67247692_buts
cuts65841152_cuts
dauts67822242dauts
emits75421472emits
emus66821682emu_s
gamuts958782gamuts
gluts66120132gluts
gouts64826172gouts
guts56637252_guts
huts76737442_huts
juts115930162_juts
louts56330272louts
mats65460292_mats
mauts75927192mauts
mots66853162_mots
muds75530662_muds
mugs76232042_mugs
mums85732772_mums
muns65535922_muns
mus55946752_mu_s
muss64933762_muss
must65145442_must
musts75527442_musts
mut58357182_mut_
mute65136872_mute
mutes75033782_mutes
mutt65739402_mutt
mutts75120252_mutts
nuts45032672_nuts
omits75018262omits
outs45746962_outs
phuts104613502phuts
pouts75530322pouts
puts65641752_puts
routs57133412routs
ruts44541492_ruts
salts55431882salts
sauls55128122sauls
saults65816172saults
saute55028082saute
sautes63924912sautes
scats75930602scats
scots74025912scots
scouts84817942scouts
scuds85116242scuds
scums95017422scums
scups95316652scups
scut65835542scut_
scuta75815752scuta
scute75520942scute
scutes85219192scutes
seats54844342seats
sects75622892sects
septs75420602septs
sets45549502s_ets
setts55124322setts
sexts125118382sexts
shits84731172shits
shots84730852shots
shouts94017722shouts
shuls85319712shuls
shuns85018142shuns
shunts95712022shunts
shut76137592shut_
shute84520352shute
shutes93518222shutes
sifts84918922sifts
silts55330822silts
sits45050212s_its
situs55019232situs
skats94621542skats
skits94721872skits
skuas95611732skuas
slats55436902slats
slits56128852slits
slots54830532slots
slubs74719532slubs
slues54527172slues
slugs64618562slugs
slums74623432slums
slurs54123372slurs
slut45040592slut_
smalts85214892smalts
smarts86218002smarts
smelts85412772smelts
smews104612292smews
smit65138412smit_
smite75224872smite
smites83921922smites
smith107818052smith
smiths114711022smiths
smogs85112162smogs
smolts84411882smolts
smote75820282smote
smug75815262smu_g
smush104410582smush
smutch13205842smutch
smutty11266322smutty
snits54124832snits
snots55225122snots
snouts64915872snouts
snubs75412552snubs
snugs64913022snugs
softs85019232softs
soots55536212soots
sorts54536662sorts
sots45552452s_ots
souks94820522souks
souls55127362souls
soups75322942soups
sours55230502sours
sous46947212sou_s
south85223572south
souths95216602souths
spats75031382spats
spits74429552spits
spots74424112spots
spouts85115112spouts
spuds85113672spuds
spues75025382spues
spurs74621522spurs
spurts84814972spurts
sputa74612962sputa
squats153712962squats
stats55933362stats
stets55423912stets
stots54828552stots
stouts65019002stouts
struts65616802struts
stubs75016072stubs
studs64415872studs
stums75320082stums
stuns54719492stuns
stunts65615252stunts
sturts63915142sturts
subs66037122s_ubs
suds56135302s_uds
sues46247652s_ues
suets55126102suets
suits55028052suits
suks85927122s_uks
sumos75720092sumos
sumps95023432sumps
sums65837582s_ums
suns45841902s_uns
sups64834432s_ups
suqs134319652s_uqs
suss45229302s_uss
swats85726862swats
swots85518432swots
tauts56125512tauts
touts54830392touts
tuts45838452_tuts
uts35534372__uts

Search took 3 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.296603685.8
2DLD Change Limit538001661.70331591.3
3Display Results1661660.0305533.3
 (SQL Overall)1786911662.02988068.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.