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

185 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
route5513207(None) 
croute84617271croute
rote46249021ro_te
rotte54625931rotte
roue45941741rou_e
rouge65423441rouge
rouse56634701rouse
rout46153281rout_
routed75624331routed
router65025841router
routes66129311routes
routh86423071routh
routs57133411routs
acute74720362acute
arbute8311042arbute
arouse65019982arouse
boite74426322boite
boule74828042boule
bouse75931852bouse
bout66353292bout_
bouts75131312bouts
brute75321782brute
bute66739672_bute
chute104316462chute
comte96125472comte
conte76633202conte
cote66648732co_te
coude85022632coude
coupe96023482coupe
couter84930202couter
couth106122482couth
croupe105114432croupe
crouse84619362crouse
croutes94815642croutes
cute66440452_cute
dote55442882do_te
douce85518422douce
douse66329722douse
drouth104410102drouth
elute54822572elute
flute86823752flute
forte86131462forte
glute66020902glute
gouge78220062gouge
gout56646002gout_
gouts64826172gouts
gouty95217362gouty
grouse74315022grouse
grout65330422grout_
grouted94111502grouted
grouter84412522grouter
grouts75015612grouts
grouty104710982grouty
haute89521612haute
house89131422house
joule124918202joule
jute115327892_jute
lotte54923852lotte
louie55023512louie
loupe75319512loupe
louse56131012louse
lout45952142lout_
louted74920692louted
louts56330272louts
lute46341012_lute
monte75829772monte
moste75925082moste
mote67048082mo_te
motte75526972motte
moue65835572mou_e
mouse77133002mouse
mouth105420292mouth
mute65136872_mute
note46239962no_te
orate55133302orate
out38072152_out_
outed65429062_outed
outer55633302_outer
outre53922192_outre
outs45746962_outs
pout65752552pout_
pouted94021392pouted
pouter83923982pouter
pouts75530322pouts
pouty107018812pouty
quote143714772quote
rate45458762r_ate
refute95515702refute
rente54733782rente
repute84716092repute
reroute7313962reroute
rete44944132r_ete
reuse56025362reuse
rite45849452r_ite
robe65335642ro_be
roble75223022roble
rode55844302ro_de
roe36861072ro__e
rogue66417532rogue
role45851822ro_le
roose56127092roose
root45655922root_
rooted75424002rooted
rooter64926032rooter
rootle63214452rootle
roots55933672roots
rooty86423022rooty
rope65542912ro_pe
roque144812132roque
roquet154415892roquet
rose46148902ro_se
roset55945242roset
roster64329082roster
rot37282952ro_t_
rota45834342ro_ta
rotate63320342rotate
rotes56143902ro_tes
roti46332922ro_ti
rotl45029682ro_tl
roto45935052ro_to
rots46454092ro_ts
rotted74524432rotted
rotten64115432rotten
rotter64325462rotter
rottes64524832rottes
rouble83913312rouble
rouche114714312rouche
rouen54920902rouen
roues56039352roues
rouged86717322rouged
rouges76022382rouges
rough97819432rough
round64318432round
roup66627692rou_p
rouped95717352rouped
roupet84218342roupet
roups75118902roups
roupy106112712roupy
roused75426442roused
rouser65224082rouser
rouses65436282rouses
roust55532062roust
rousted84013322rousted
rouster73517082rouster
rousts617016722rousts
routers74822852routers
rouths95416822rouths
routine72615902routine
roux117419362rou_x
rove75136982ro_ve
rowth115713232rowth
rube65532012r_ube
rude55632782r_ude
rue35549262r_u_e
rule49938422r_ule
rune45236292r_une
ruse45938932r_use
rut35560522r_ut_
ruth76825992r_uth
ruts44541492r_uts
saute55028082saute
scute75520942scute
shute84520342shute
solute64016662solute
souse56530772souse
souter64225922souter
south85223572south
torte55431702torte
tote46643672to_te
touse55430672touse
tout46753822tout_
touted74419742touted
touter63821032touter
touts54830392touts
troupe84812432troupe
trout57332572trout_
trouts66116622trouts
trouty95211792trouty
ute35335882__ute
volte85321302volte
volute93912762volute
vote74728622vo_te
wrote84717482wro_te
youse85322232youse
youth115315042youth

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.1701051123.5
2DLD Change Limit538001851.93627789.3
3Display Results1851850.0503700.0
 (SQL Overall)1786911852.15682880.8
 
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.