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

282 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
routs5713341(None) 
bouts75131311bouts
gouts64826171gouts
grouts75015611grouts
louts56330271louts
outs45746961_outs
pouts75530321pouts
roots55933671roots
rots46454091ro_ts
roues56039351roues
roups75118901roups
roust55532061roust
rousts617016721rousts
rout46153281rout_
route55132071route
routes66129311routes
routh86423071routh
rouths95416821rouths
ruts44541491r_uts
touts54830391touts
trouts66116631trouts
abuts75417072abuts
bhuts105812952bhuts
boats75635152boats
bolts76232112bolts
boots75837972boots
borts76735452borts
bots66453952bo_ts
botts75224862botts
bout66353292bout_
bruts75922952bruts
buts67247692_buts
clouts87017202clouts
coats75635002coats
colts76633292colts
coots75636842coots
costs77231142costs
cots68054842co_ts
counts84618272counts
coups95522472coups
courts84216172courts
couth106122492couth
couths115715412couths
crofts114910592crofts
croups104312552croups
croute84617272croute
croutes94815652croutes
cuts65841152_cuts
dauts67822242dauts
doats65224882doats
doits66223672doits
dolts65626312dolts
donuts7410582donuts
dots55647662do_ts
doubts968732doubts
doums85417642doums
droits74314312droits
drouks1137122drouks
drouth104410102drouth
drouths11436482drouths
flouts94315272flouts
fonts86124752fonts
foots85528282foots
forts86034452forts
fouls87221432fouls
founts94313382founts
fours85521492fours
fronts94415792fronts
frosts94214622frosts
glouts74414712glouts
gluts66120132gluts
goats65527302goats
gout56646002gout_
gouty95217362gouty
groats74816652groats
grots65025852gro_ts
groups94210512groups
grout65330422grout_
grouty104710982grouty
guts56637252_guts
holts85627912holts
hoots84830252hoots
hosts85526702hosts
hots78349332ho_ts
hours85422392hours
huts76737442_huts
jolts125018882jolts
jots116336142jo_ts
jouks165612342jouks
joust125122292joust
jousts135011272jousts
juts115930162_juts
knouts10438312knouts
krauts10418512krauts
lofts85518362lofts
loots55431422loots
lots47652092lo_ts
lotus55718062lotus
louis57322322louis
loups75319622loups
lours55125292lours
lout45952142lout_
mauts75927192mauts
moats75827642moats
molts76032092molts
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162mo_ts
motts76527002motts
moues75732842moues
moults84713702moults
mounts84115072mounts
mouth105420292mouth
mouths115214532mouths
muts64839982_muts
nouns56717312nouns
nous46136982nou_s
nowts86915862nowts
nuts45032672_nuts
oats46554212_oats
oots46446442_oots
opts68124742_opts
orts46538332_orts
ouds56430102_ouds
ours47237562_ours
oust46747442_oust
ousts55225702_ousts
out38072152_out_
phuts104613502phuts
poets76024442poets
ports75934592ports
posts75228782posts
pots66452362po_ts
poufs105616062poufs
poults84613482poults
pours74623182pours
pout65752552pout_
pouty107018812pouty
puts65641752_puts
rafts87820632rafts
ragouts838542ragouts
rants55935342rants
rats46260372r_ats
rebuts84015192rebuts
recuts83817372recuts
redouts81411662redouts
rents55935182rents
rests54935872rests
rets45352562r_ets
rhus75114052rhu_s
rifts85718642rifts
riots54922012riots
roads66523622roads
roams74919612roams
roans54926442roans
roars55622242roars
roast56230142roast
roasts64915412roasts
robes75133302robes
robots8313152robots
robs65837872ro_bs
robust8310432robust
rocks114626412rocks
rocs65533662ro_cs
rodes614039082rodes
rods56442062ro_ds
roes45954142ro_es
rogues74617672rogues
roils54826792roils
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
romps94617542romps
roms67038962ro_ms
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roost55730932roost
roosts64916322roosts
root45655922root_
rooty86423022rooty
ropes75940062ropes
roques154912562roques
roquets16398942roquets
roses56445772roses
rosets65819952rosets
rot37282952ro_t_
rota45834342ro_ta
rotas54827722rotas
rote46249022ro_te
rotes56143902rotes
rotguts833762rotguts
roti46332932ro_ti
rotis56327062rotis
rotl45029682ro_tl
rotls55620162rotls
roto45935052ro_to
rotos56027882rotos
rotte54625932rotte
rottes64524832rottes
roue45941742rou_e
rouen54920902rouen
rouens64814442rouens
rouge65423442rouge
rouges76022382rouges
rough97819432rough
roughs105416212roughs
round64318432round
rounds73615622rounds
roup66627692rou_p
roupy106112712roupy
rouse56634702rouse
rouses65436282rouses
routed75624332routed
router65025842router
routers74822872routers
roux117419362rou_x
roves84834482roves
rows75941752ro_ws
rowth115713232rowth
rowths12458172rowths
rubouts937982rubouts
rubs66133492r_ubs
rues46044482r_ues
rugs56033682r_ugs
rums64833472r_ums
runouts737352runouts
runs46438072r_uns
runts55927632runts
rust45544912r_ust
rusts55026992rusts
rut35560522r_ut_
ruth76825992r_uth
ruths85714642r_uths
ryots85313782ryots
scouts84817942scouts
scuts74522522scuts
shouts94017722shouts
shuts85622482shuts
sluts54523982sluts
smuts75415712smuts
snouts64915872snouts
softs85019232softs
soots55536212soots
sorts54536662sorts
sots45552452so_ts
souks94820522souks
souls55127362souls
soups75322942soups
sours55230502sours
sous46947212sou_s
south85223572south
souths95216602souths
spouts85115112spouts
sprouts949982sprouts
stouts65019002stouts
tauts56125512tauts
tofts84919242tofts
toits55327472toits
toots55331872toots
torts56138122torts
tots46654122to_ts
tours55325892tours
tout46753822tout_
trots56629942tro_ts
trout57332572trout_
trouty95211792trouty
tryouts1035312tryouts
tuts45838452_tuts
uts35534372__uts
volts85421292volts
vrouws12494742vrouws
wonts87621542wonts
worts88631182worts
wots76342892wo_ts
yours85217882yours
yous76230652you_s
youth115315042youth
youths124510042youths
zouks184410502zouks

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.0931921408.6
2DLD Change Limit538002824.36012339.4
3Display Results2822820.0763710.5
 (SQL Overall)1786912824.52939454.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.