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

208 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
rouse5663470(None) 
arouse65019981arouse
bouse75931851bouse
crouse84619361crouse
douse66329721douse
grouse74315021grouse
house89131421house
louse56131011louse
mouse77133001mouse
reuse56025361reuse
roose56127091roose
rose46148901ro_se
roue45941741rou_e
roues56039351roues
rouge65423441rouge
roused75426441roused
rouser65224081rouser
rouses65436281rouses
roust55532061roust
route55132071route
ruse45938931r_use
souse56530771souse
touse55430671touse
youse85322231youse
abuse77119562abuse
amuse75920832amuse
arose55832082aro_se
aroused84914342aroused
arouser74514422arouser
arouses74921292arouses
blouse84714722blouse
boule74828042boule
bourse84414332bourse
boused95322882boused
bouses84931782bouses
bousy104917842bousy
bowse105420632bowse
brose75227032bro_se
browse115713852browse
carouse9614422carouse
cause75225352cause
chouse116017562chouse
copse95623922copse
corse75036182corse
coude85022632coude
coupe96023482coupe
course85117782course
crosse85216302crosse
croupe105114432croupe
croute84617272croute
cruse75726102cruse
dose56442432do_se
douce85518422douce
doused84821162doused
douser75621632douser
douses74928932douses
dowse96020812dowse
drowse105010552drowse
druse64817662druse
erose55727272ero_se
fosse86119462fosse
fuse76429992_fuse
goose65925902goose
gorse65926812gorse
gouge78220062gouge
groused94712832groused
grouser84513692grouser
grouses84616542grouses
hoise85224772hoise
horse86132652horse
hose76547242ho_se
housed105624102housed
housel95217052housel
houser95322282houser
houses96032282houses
joule124918202joule
joust125122292joust
loose56627682loose
lose45144582lo_se
louie55023512louie
loupe75319512loupe
loused74822912loused
louses66230282louses
lousy84617082lousy
lowse87219902lowse
moose76327192moose
morse76032702morse
moue65835572mou_e
moues75732842moues
moused94423302moused
mouser85822442mouser
mouses85531422mouses
mousey115216192mousey
mousse84813032mousse
mousy106716942mousy
muse67136032_muse
noise55723732noise
nonuse63212252nonuse
noose55624062noose
nose46739362no_se
nous46136982nous_
nouses64627162nouses
ose38147342_o_se
ousel55222402_ousel
oust46747442_oust
owse76321622_owse
pause75021832pause
poise75127892poise
pose66441732po_se
posse74722272posse
profuse1237152profuse
prose75835122pro_se
raise54828052raise
rase46149982r_ase
recuse85519162recuse
refuse94817512refuse
rehouse10311772rehouse
retuse66617222retuse
reused75419562reused
reuses66025522reuses
rhus75114052rhus_
rhuses94911792rhuses
rinse54820972rinse
rise45945232r_ise
roast56230142roast
robe65335642ro_be
robes75133302robes
roble75223022roble
robs65837872robs_
robust8310432robust
rocs65533662rocs_
rode55844302ro_de
rodes614039082rodes
rods56442062rods_
roe36861082ro__e
roes45954142roes_
rogue66417532rogue
rogues74617672rogues
role45851822ro_le
roles56747982roles
roms67038962roms_
roosed75621592roosed
rooser63921882rooser
rooses65526242rooses
roost55730932roost
rope65542912ro_pe
ropes75940062ropes
roque144812132roque
roques154912562roques
rosed65930342ro_sed
roses56445772ro_ses
roset55945242ro_set
rosy76024872ro_sy
rote46249022ro_te
rotes56143902rotes
rots46454092rots_
rotte54625932rotte
rouble83913312rouble
rouche114714312rouche
rouen54920902rouen
rouged86717322rouged
rouges76022382rouges
rough97819442rough
round64318432round
roup66627692rou_p
rouped95717352rouped
roupet84218342roupet
roups75118902roups
roupy106112712roupy
rousers75220142rousers
rousted84013322rousted
rouster73517082rouster
rousts617016722rousts
rout46153282rou_t
routed75624332routed
router65025842router
routes66129312routes
routh86423072routh
routs57133412routs
roux117419362rou_x
rove75136982ro_ve
roves84834482roves
rows75941752rows_
rube65532012r_ube
rude55632782r_ude
rue35549262r_u_e
rues46044482r_ues
rule49938422r_ule
rune45236302r_une
ruses56136582r_uses
rush76628182r_ush
rusk85823312r_usk
rust45544912r_ust
scouse84113632scouse
sous46947212sous_
soused74822982soused
souses64229242souses
spouse84112512spouse
torse55833332torse
toused74122012toused
touses64229672touses
tousle64514652tousle
troupe84812432troupe
trouser73812472trouser
uprouse937222uprouse
use36835162__use
worse86525262worse
yous76230652yous_

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.300595636.7
2DLD Change Limit538002081.64032804.9
3Display Results2082080.0603466.7
 (SQL Overall)1786912082.00089345.5
 
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.