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 “rouser” 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
rouser6522408(None) 
arouser74514421arouser
douser75621631douser
grouser84513691grouser
houser95322281houser
mouser85822441mouser
rooser63921881rooser
rouse56634701rouse_
roused75426441roused
rousers75220141rousers
rouses65436281rouses
rouster73517081rouster
router65025841router
trouser73812471trouser
abuser85413682abuser
amuser84712622amuser
arouse65019982arouse_
aroused84914342aroused
arousers84810982arousers
arouses74921292arouses
bouse75931852bouse_
boused95322882boused
bouses84931782bouses
browser124911142browser
carouser1068842carouser
causer84117782causer
chouser125212942chouser
courser94114802courser
couter84930222couter
crosser95015462crosser
crouse84619362crouse_
dorser74819182dorser
doser66228562do_ser
dosser74417972dosser
dourer74215272dourer
douse66329722douse_
doused84821162doused
dousers84817272dousers
douses74928932douses
dowser104716082dowser
focuser12155782focuser
fouler93614902fouler
gouger86014362gouger
grosser84313142grosser
grouper104210092grouper
grouse74315022grouse_
groused94712832groused
grousers93810732grousers
grouses84616542grouses
grouter84412522grouter
hoser811529762ho_ser
house89131422house_
housed105624102housed
housel95217042housel
housers104717812housers
houses96032272houses
jouster143311042jouster
looser65219942looser
loser54728672lo_ser
louder74414602louder
louse56131012louse_
loused74822912loused
louses66230282louses
lousier72411622lousier
louver94110392louver
momser104011412momser
mosser84618272mosser
mouse77133002mouse_
moused94423302moused
mousers95216442mousers
mouses85531422mouses
mousey115216192mousey
mousier93712462mousier
muser76024122_muser
nonuser7299142nonuser
nooser65517822nooser
nouses64627162nouses
ousel55222402_ousel
ouster64223732_ouster
outer55633302_outer
pauser84415962pauser
poiser84217242poiser
poser75128772po_ser
pourer84516042pourer
pouter83923982pouter
proser84223462pro_ser
prouder10310382prouder
raiser66620102raiser
raser55633412r_aser
refuser104912782refuser
reuse56025362reuse_
reused75419562reused
reuses66025522reuses
rhuses94911792rhuses
rinser64317212rinser
riser55431052r_iser
roamer84715162roamer
roarer63914332roarer
roaster74116662roaster
robber103916532robber
robuster1035662robuster
rocker124319572rocker
roger64521412ro_ger
roister73516202roister
rolfer94412272rolfer
roller63919792roller
romper104213682romper
roofer94415282roofer
roomer84718632roomer
roose56127092roose_
roosed75621592roosed
roosers74217872roosers
rooses65526232rooses
rooster74415172rooster
rooter64926032rooter
roper75431912ro_per
ropier84118802ropier
rose46148902ro_se_
rosed65930342ro_sed
rosery93813282ro_sery
roses56445772ro_ses
roset55945242ro_set
rosier64221262rosier
roster64329082roster
rotter64325462rotter
roue45941742rou_e_
rouen54920902rou_en
roues56039352rou_es
rouge65423442rouge_
rouged86717322rouged
rouges76022382rouges
rougher113511032rougher
rounder83514602rounder
rouped95717352rouped
roupet84218342roupet
roupier9319492roupier
roust55532062rous_t
rousted84013322rousted
rousters84315682rousters
rousts617016722rousts
route55132072route_
routed75624332routed
routers74822872routers
routes66129312routes
rover85527372ro_ver
rower85430492ro_wer
royster103110532royster
rozzer1437352rozzer
ruder65320542r_uder
ruer46127562r_u_er
ruler54923342r_uler
ruse45938932r_use_
ruses56136582r_uses
rusher94019652r_usher
sourer63620212sourer
souse56530772souse_
soused74822982soused
souses64229242souses
souter64225922souter
tosser64215662tosser
tourer64115072tourer
touse55430672touse_
toused74122012toused
touses64229672touses
touter63821032touter
trouper93811432trouper
trousers83910632trousers
user45023002__user
worser95117522worser
wowser125110202wowser
youse85322232youse_

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 Limit825511712.59331836.1
3Display Results1711710.0463717.4
 (SQL Overall)1786911712.74965002.2
 
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.