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 “roughen” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

198 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
roughen1133883(None) 
roughed124210941roughed
roughens12286891roughens
rougher113511031rougher
toughen11329201toughen
boughed143810262boughed
boughten1444192boughten
coughed143310902coughed
cougher133711732cougher
foughten1544002foughten
rouche114714312rouche_
rouches124217892rouches
rouen54920902rou__en
rouge65423442roug_e_
rouged86717322roug_ed
rouges76022382roug_es
rough97819442rough__
roughened1444092roughened
roughers12329182roughers
roughest1238772roughest
roughhew1842872roughhew
roughhewn1951642roughhewn
roughies1298322roughies
roughing13278342roughing
roughleg1343402roughleg
roughly14507292roughly
roughs105416222rough_s
roughy137010862rough_y
soughed123811622soughed
toughed123511692toughed
toughens12286722toughens
tougher114210982tougher
youthen1336152youthen
bouchee143313543bouchee
bough115719313bough__
boughs125414373bough_s
bought125115643bough_t
bougie93613273bougie_
bougies103715183bougies
bounden10389453bounden
brougham1642973brougham
brought13308693brough_t
couched154115793couched
coucher144515853coucher
couches144020473couches
cough115819643cough__
coughers14399963coughers
coughing15309213coughing
coughs125514543cough_s
couther123914633couther
crouched16359153crouched
crouches153711293crouches
douche124613223douche_
douched144012113douched
douches134315233douches
dough105217383dough__
doughier1335483doughier
doughs115912933dough_s
dought114915523dough_t
doughty15436023doughty
doughy14499843dough_y
drought12258883drough_t
droughts13245743droughts
droughty16304483droughty
fought135112403fough_t
frogmen1335893fro_gmen
gorhen1038903go_rhen
gouge78220063goug_e_
gouged96214593goug_ed
gouger86014363goug_er
gouges86318693goug_es
groschen1442973groschen
grouched15356663grouched
grouches14328213grouches
kuchen1536653_kuchen
laughed1235893laughed
laugher1136603laugher
louche115212663louche_
louden73711793lou_den
lough95118483lough__
loughs105014773lough_s
loupen84510293lou_pen
moorhen1236023moorhen
morgen9312203morg_en
mouched153612593mouched
mouches143815963mouches
mouthed133811043mouthed
mouther123812813mouther
mudhen1236883_mudhen
nought104713973nough_t
noughts11478083noughts
ouched124316933_ouched
ouches114322183_ouches
ought95221543_ough_t
oughted1236223_oughted
oughts104710183_oughts
ouphe104413263_ouphe_
ouphes113614633_ouphes
ploughed15204303ploughed
plougher14214463plougher
pouched153612773pouched
pouches144116743pouches
ragmen93712183r_agmen
richen113812513r_ichen
roached133211833roached
roaches123616213roaches
rochet115423003ro_chet
rodmen939713ro_dmen
rodsmen1035833rodsmen
roger64521413ro_g_er
rogue66417533ro_gue_
rogued84711473ro_gued
rogues74617673ro_gues
rontgen835173rontgen
rotche114311983rotche_
rotches123515703rotches
rotten64115433ro_tten
rouble83913313rouble_
roubles93413513roubles
roue45941743rou__e_
rouens64814443rou__ens
roues56039353rou__es
roughage1344423roughage
roughages1444383roughages
roughdry1692543roughdry
roughening1543393roughening
roughhews1942193roughhews
roughish1545213roughish
roughlegs1442583roughlegs
roughneck1972263roughneck
roughness1345763roughness
rouging93114703rouging
rounded93013503rounded
roundel8308853roundel
rounder83514613rounder
rouped95717353rou_ped
roupet84218343rou_pet
roupier9319493roupier
rouse56634703rou_se_
roused75426453rou_sed
rouser65224083rou_ser
rouses65436283rou_ses
rousted84013333rousted
rouster73517083rouster
route55132073rou_te_
routed75624333rou_ted
routemen10105813routemen
router65025843rou_ter
routes66129313rou_tes
routh86423073routh__
rouths95416823routh_s
routine72615903routine
roven85521973ro__ven
rowen84921153ro__wen
ruche104216763r_uche_
ruched124314633r_uched
ruches114819583r_uches
rugae65114763r_ugae_
rugged94215383r_ugged
rugger84414513r_ugger
rumen74419503r_u_men
rushed104419863r_ushed
rushee93818773r_ushee
rusher94019653r_usher
rushes94724363r_ushes
sloughed13305583sloughed
sough95320463sough__
soughing13259733soughing
soughs105115623sough_s
sought106315063sough_t
southed114313993southed
souther104116303souther
southern11438913southern
sughed113610203_sughed
tongmen1037123tongmen
touche114916173touche_
touched134914963touched
toucher124814353toucher
touches125118343touches
tough97321993tough__
toughened1444223toughened
toughener1344163toughener
toughest1238303toughest
toughie1187593toughie
toughies1278243toughies
toughing13278553toughing
toughly14487433toughly
toughs105414993tough_s
toughy135911083tough_y
trough108512033trough__
troughs11698693trough_s
vouched163910563vouched
vouchee153411263vouchee
voucher154110263voucher
vouches153914113vouches
woodhen1454723woodhen
wrought14276933wrough_t
youthens1435383youthens

Search took 8 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 Filter1786911340270.440406115.9
2DLD Change Limit1340271987.00019146.7
3Display Results1981980.0603300.0
 (SQL Overall)1786911987.50023825.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.