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

114 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
ruths8571464(None) 
rouths95416821rouths
ruth76825991ruth_
ruts44541491rut_s
truths9449501truths
autos56523322autos
baths105922922baths
beths105519222beths
briths115113862briths
broths115013922broths
brughs12509062brughs
brutes86118682brutes
bruts75922952brut_s
butes714535872butes
buts67247692but_s
butts75824252butts
couths115715412couths
crwths1433432crwths
cutes79438322cutes
cutis77723762cutis
cuts65841152cut_s
drouths11436482drouths
eths76619522_eths
friths124313582friths
froths125411442froths
goths96513002goths
griths105211652griths
guts56637252gut_s
heths116317782heths
huts76737442hut_s
jutes125125132jutes
juts115930162jut_s
kiths125814972kiths
laths86022402laths
lutes55836662lutes
maths105624022maths
meths105320232meths
moths106021552moths
mouths115214532mouths
musths11589482musths
mutes75033782mutes
muts64839982mut_s
mutts75120252mutts
myths135911602myths
nuts45032672nut_s
oaths86117312oaths
ouphs104311272ouphs
outs45746962out_s
paths105521382paths
piths105817542piths
puts65641752put_s
putts75719272putts
rates55352012rates
rath76037662rath_
rathe85821922rathe
ratos55528762ratos
rats46260372rat_s
rets45352562ret_s
rites54442552rites
rotas54827722rotas
rotes56143902rotes
rotis56327062rotis
rotls55620162rotls
rotos56027882rotos
rots46454092rot_s
roughs105416212roughs
routes66129312routes
routh86423072routh_
routs57133412rout_s
rowths12458172rowths
rubes74928412rubes
rubs66133492ru_bs
rubus76415062rubus
ruche104216762ruche
ruches114819582ruches
rucks114422052rucks
rudds74811702rudds
ruers515019412ruers
rues46044482ru_es
ruffs114516742ruffs
rugs56033682ru_gs
ruins55822032ruins
rules55234252rules
rumps95922292rumps
rums64833472ru_ms
runes55530222runes
rungs611819402rungs
runs46438072ru_ns
runts55927632runts
ruses56136582ruses
rush76628182rush_
rushes94724362rushes
rushy115414812rushy
rusks95816192rusks
rusts55026992rusts
rut35560522rut__
rutin55421342rutin
rutins63818392rutins
rutty85617802rutty
soths86218632soths
souths95216602souths
sughs95313322sughs
teths85418512teths
troths95414152troths
truth85214152truth_
tuts45838452tut_s
tutus55214812tutus
ughs85410972_ughs
utas45924952_utas
utes45930882_utes
uts35534372_ut_s
vughs12678742vughs
wraths123810082wraths
youths124510042youths

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.610292936.1
2DLD Change Limit538001142.84318923.7
3Display Results1141140.0303800.0
 (SQL Overall)1786911143.48351303.8
 
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.