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

217 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
shuts8562247(None) 
bhuts105812951bhuts
huts76737441_huts
phuts104613501phuts
scuts74522521scuts
shits84731161shits
shots84730831shots
shouts94017711shouts
shuls85319711shuls
shuns85018141shuns
shunts95712011shunts
shut76137581shut_
shute84520341shute
shutes93518211shutes
sluts54523981sluts
smuts75415711smuts
abuts75417072abuts
bhut95425712bhut_
bouts75131312bouts
bruts75922952bruts
buts67247692_buts
chats105730092chats
chits105424572chits
chubs125412622chubs
chugs115511942chugs
chums125015832chums
chute104316462chute
chutes114615762chutes
cuts65841152_cuts
dauts67822242dauts
dhuti937522dhuti
dhutis1035922dhutis
ghats95818612ghats
ghauts10447782ghauts
gluts66120132gluts
gouts64826172gouts
guts56637252_guts
hats76858252_hats
hets75547202_hets
hits75545132_hits
hots78349322_hots
hubs96027142_hubs
hues75235232_hues
hugs86129752_hugs
hums96831422_hums
huns76136932_huns
hunts86826172_hunts
hurts86922822_hurts
hut66457292_hut_
juts115930162_juts
khats125316012khats
khets124913432khets
louts56330272louts
mauts75927192mauts
muts64839982_muts
nuts45032672_nuts
outs45746962_outs
phots105418492phots
phut96925972phut_
pouts75530322pouts
puts65641752_puts
rhus75114052rhu_s
routs57133412routs
ruts44541492_ruts
salts55431882salts
sauls55128122sauls
saults65816172saults
saute55028082saute
sautes63924912sautes
scats75930602scats
schuits1235822schuits
schuls11299852schuls
schuss11186732schuss
scots74025902scots
scouts84817942scouts
scuds85116242scuds
scums95017422scums
scups95316652scups
scut65835542scut_
scuta75815752scuta
scute75520942scute
scutes85219192scutes
seats54844342seats
sects75622892sects
septs75420602septs
sets45549502s_ets
setts55124322setts
sexts125118382sexts
shads95124482shads
shafts125411432shafts
shags95123862shags
shahs115919512shahs
shams105829412shams
shat76456592shat_
shauls94913112shauls
shaws116226262shaws
shays116021432shays
sheas86331792sheas
sheds96122702sheds
sheets93918492sheets
shes75734352sh_es
shews115924712shews
shies86136552shies
shifts124412932shifts
shims104422542shims
shins85131042shins
ships105123772ships
shirts94918332shirts
shist84829602shist
shists96515102shists
shit76745932shit_
shivs115018802shivs
shlubs11386732shlubs
shoats94117072shoats
shoes85429652shoes
shogs95319702shogs
shoos84226352shoos
shoots94619342shoots
shops104222892shops
shorts95321732shorts
shot76150242shot_
shote85526082shote
shotes95321892shotes
shott85332172shott
shotts93614682shotts
shout85433162shout_
shows115324572shows
shris84221442shris
shrubs11409212shrubs
shrugs10469162shrugs
shuck144314532shuck
shucks154010412shucks
shul75823152shu_l
shuln84713112shuln
shun75122772shu_n
shunt85226502shunt
shush113812542shush
shuted103913162shuted
shwas116415102shwas
sifts84918922sifts
silts55330822silts
sits45050202s_its
situs55019232situs
skats94621532skats
skits94721852skits
skuas95611732skuas
slats55436902slats
slits56128852slits
slots54830522slots
slubs74719532slubs
slues54527172slues
slugs64618562slugs
slums74623432slums
slurs54123372slurs
slut45040592slut_
smut66629782smut_
snits54124832snits
snots55225102snots
snouts64915862snouts
snubs75412552snubs
snugs64913022snugs
softs85019232softs
soots55536202soots
sorts54536662sorts
sots45552442s_ots
souks94820522souks
souls55127362souls
soups75322942soups
sours55230502sours
sous46947212sou_s
south85223572south
souths95216602souths
spats75031382spats
spits74429552spits
spots74424102spots
spouts85115112spouts
spuds85113672spuds
spues75025382spues
spurs74621522spurs
spurts84814972spurts
sputa74612962sputa
squats153712962squats
stats55933362stats
stets55423912stets
stots54828542stots
stouts65019002stouts
struts65616802struts
stubs75016072stubs
studs64415872studs
stums75320082stums
stuns54719492stuns
stunts65615252stunts
sturts63915142sturts
subs66037122s_ubs
suds56135292s_uds
sues46247652s_ues
suets55126102suets
suits55028052suits
suks85927122s_uks
sums65837582s_ums
suns45841902s_uns
sups64834432s_ups
suqs134319652s_uqs
suss45229302s_uss
swats85726862swats
swots85518422swots
tauts56125512tauts
thuds95110132thuds
thugs95611992thugs
thus76721472thu_s
touts54830392touts
tuts45838452_tuts
uts35534372__uts
whats117718992whats
whets115019612whets
whits115923822whits
whups134210002whups

Search took 4 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.0931921408.6
2DLD Change Limit538002172.75319542.3
3Display Results2172170.293740.6
 (SQL Overall)1786912173.13956926.1
 
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.