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

187 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
router6502584(None) 
couter84930221couter
grouter84412521grouter
outer55633301_outer
pouter83923981pouter
rooter64926031rooter
roster64329081roster
rotter64325461rotter
rouser65224081rouser
rouster73517081rouster
route55132071route_
routed75624331routed
routers74822871routers
routes66129311routes
souter64225921souter
touter63821031touter
acuter84412862acuter
arouser74514422arouser
boater84622092boater
bolter83920752bolter
clouter93511692clouter
coater84329572coater
colter84625092colter
cooter85128612cooter
copter109822012copter
coster84331292coster
cotter84926672cotter
coulter94115602coulter
counter94220152counter
courter94516482courter
couters93827302couters
couther123914632couther
crofter12299572crofter
croute84617272croute_
croutes94815652croutes
cuter74728232_cuter
doter65428622do_ter
dotter74419342dotter
doubter10298352doubter
dourer74215272dourer
douser75621632douser
flouter104311342flouter
fluter95316862fluter
footer94320772footer
foster94322222foster
fouler93614902fouler
fronter103611582fronter
goiter74116202goiter
gouger86014362gouger
goutier82612352goutier
grouper104210092grouper
grouser84513692grouser
grouted94111502grouted
grouters95910082grouters
groutier9297172groutier
hooter94123932hooter
hotter94720082hotter
houser95322282houser
jolter133513092jolter
jotter134315632jotter
jouster143311042jouster
lofter94614722lofter
loiter64619172loiter
looter64222322looter
lotter64025602lotter
louder74414602louder
louted74920692louted
louver94110392louver
molter84119422molter
mooter83921092mooter
moulter93812422moulter
mounter93713172mounter
mouser85822442mouser
mouther123812812mouther
muter74525542_muter
neuter63713792neuter
noter55025642no_ter
oater55433732_oater
ofter84116872_ofter
otter54423972_otter
ouster64223732_ouster
outed65429062_outed
outers64230172_outers
outre53922202_outre
oxter123414092_oxter
porter84224412porter
poster84129172poster
potter83926982potter
poulter93712012poulter
pourer84516042pourer
pouted94021392pouted
pouters94221872pouters
poutier93215322poutier
powter114116032powter
prouder10310382prouder
quoter153510092quoter
rafter94517582rafter
ranter63826822ranter
raster64731442raster
rater54943282r_ater
ratter64326312ratter
refuter104312192refuter
renter64527412renter
rester63832432rester
reutter71010092reutter
rioter64817282rioter
ritter63822422ritter
roamer84715162roamer
roarer63914332roarer
roaster74116662roaster
robber103916532robber
robuster1035662robuster
rocker124319572rocker
roger64521412ro_ger
roister73516202roister
rolfer94412272rolfer
roller63919792roller
romper104213682romper
roofer94415282roofer
roomer84718632roomer
rooser63921882rooser
rooster74415172rooster
rooted75424002rooted
rooters74522932rooters
rootier74915392rootier
roper75431912ro_per
ropier84118802ropier
rosier64221262rosier
rosters73727542rosters
rote46249022ro_te_
rotes56143902ro_tes
rotor55519732ro_tor
rotte54625932rotte_
rotted74524432rotted
rotten64115432rotten
rotters74421392rotters
rottes64524832rottes
roue45941742rou_e_
rouen54920902rou_en
roues56039352rou_es
rouge65423442rouge_
rouged86717322rouged
rouges76022382rouges
rougher113511032rougher
rounder83514602rounder
rouped95717352rouped
roupet84218342roupet
roupier9319492roupier
rouse56634702rouse_
roused75426442roused
rousers75220142rousers
rouses65436282rouses
rousted84013322rousted
rousters84315682rousters
rout46153282rout__
routh86423072rout_h
rouths95416822rouths
routs57133412rout_s
rover85527372ro_ver
rower85430492ro_wer
royster103110532royster
rozzer1437352rozzer
ruder65320542r_uder
ruer46127562r_u_er
ruler54923342r_uler
scouter93313322scouter
shouter103213082shouter
softer94015312softer
sorter64425092sorter
sourer63620212sourer
souters74422602souters
souther104116302souther
spouter94213222spouter
stouter74012052stouter
tauter64318022tauter
tooter64420802tooter
toter55932132to_ter
totter65021462totter
tourer64115072tourer
touted74419742touted
touters74018352touters
trotter73312252trotter
trouper93811432trouper
trouser73812472trouser
troutier8277152troutier
voter85121052vo_ter
zoster153715852zoster

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 Filter178691825510.1101624463.6
2DLD Change Limit825511872.23336968.7
3Display Results1871870.0632968.3
 (SQL Overall)1786911872.40674268.9
 
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.