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

171 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
routes6612931(None) 
croutes94815641croutes
rotes56143901ro_tes
rottes64524831rottes
roues56039351rou_es
rouges76022381rouges
rouses65436281rouses
route55132071route_
routed75624331routed
router65025841router
routers74822851routers
rouths95416821rouths
routs57133411rout_s
acutes83917722acutes
arbutes939702arbutes
arouses74921292arouses
boites84322702boites
boules84925972boules
bouses84931782bouses
bouts75131312bout_s
brutes86118682brutes
butes714535872_butes
chutes114615762chutes
comtes106222812comtes
contes84432912contes
cotes76347842co_tes
coupes105022522coupes
couter84930202couter
couters93827282couters
couths115715392couths
croupes114613102croupes
croute84617272croute_
cutes79438312_cutes
dotes65836692do_tes
douses74928932douses
drouths11436482drouths
elutes64020312elutes
flutes95421782flutes
fortes95327182fortes
frontes104214162frontes
glutes74517672glutes
gouges86318692gouges
gouts64826172gout_s
grouses84616542grouses
grouted94111502grouted
grouter84412522grouter
grouters95910062grouters
grouts75015612grout_s
houses96032272houses
joules134116822joules
jutes125125132_jutes
lottes65322752lottes
louies64525102louies
loupes84918052loupes
louses66230282louses
louted74920692louted
louts56330272lout_s
lutes55836662_lutes
montes84226932montes
motes75944002mo_tes
mottes85523692mottes
moues75732842mou_es
mouses85531422mouses
mouths115214532mouths
mutes75033782_mutes
notes55034582no_tes
nouses64627162nouses
orates64328612orates
outed65429062_outed
outer55633302_outer
outers64230162_outers
outs45746962_out_s
pontes83627852pontes
pouted94021392pouted
pouter83923982pouter
pouters94221862pouters
pouts75530322pout_s
quotes153312462quotes
rates55352012r_ates
refutes104515722refutes
rentes65431192rentes
reputes94615962reputes
reroutes8312222reroutes
reuses66025522reuses
rhuses94911792rhuses
rites54442552r_ites
robes75133302ro_bes
robles85321692robles
rodes614039082ro_des
roes45954132ro__es
rogues74617672rogues
roles56747982ro_les
rooses65526232rooses
rooted75424002rooted
rooter64926032rooter
rooters74522932rooters
rootles73215632rootles
roots55933672root_s
ropes75940062ro_pes
roques154912562roques
roquets16398942roquets
roses56445772ro_ses
rosets65819952rosets
roster64329082roster
rosters73727532rosters
rotas54827722ro_tas
rotates72819772rotates
rote46249022ro_te_
rotis56327052ro_tis
rotls55620162ro_tls
rotos56027882ro_tos
rots46454092ro_t_s
rotte54625932rotte_
rotted74524432rotted
rotten64115432rotten
rotter64325462rotter
rotters74421392rotters
roubles93413502roubles
rouches124217892rouches
roue45941742rou_e_
rouen54920902rou_en
rouens64814442rouens
rouge65423442rouge_
rouged86717322rouged
roughs105416212roughs
rounds73615612rounds
rouped95717352rouped
roupet84218342roupet
roups75118902rou_ps
rouse56634702rouse_
roused75426442roused
rouser65224082rouser
rousers75220132rousers
rousted84013322rousted
rouster73517082rouster
rousters84315652rousters
rousts617016722rousts
rout46153282rout__
routh86423072rout_h
routines82214362routines
roves84834482ro_ves
rowths12458172rowths
rubes74928412r_ubes
rues46044482r_u_es
rules55234252r_ules
runes55530222r_unes
ruses56136582r_uses
ruths85714642r_uths
ruts44541492r_ut_s
sautes63924912sautes
scutes85219192scutes
shutes93518212shutes
solutes73515262solutes
souses64229242souses
souter64225922souter
souters74422582souters
souths95216602souths
tortes64826052tortes
totes55139682to_tes
touses64229672touses
touted74419742touted
touter63821032touter
touters74018332touters
touts54830392tout_s
troupes94112842troupes
trouts66116622trout_s
utes45930882__utes
voltes94915582voltes
volutes102710982volutes
votes84627082vo_tes
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 Filter178691825510.1101624463.6
2DLD Change Limit825511713.00027517.0
3Display Results1711710.0463717.4
 (SQL Overall)1786911713.15656619.5
 
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.