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

297 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
roughing1327834(None) 
coughing15309211coughing
rouging93114701roug_ing
soughing13259731soughing
toughing13278551toughing
couching163213262couching
crouching1746382crouching
douching15349842douching
gouging103410702goug_ing
grouching1644942grouching
laughing1335932laughing
mouching163110582mouching
mouthing142810242mouthing
ouching134314902_ouching
oughting1335952_oughting
ploughing16203672ploughing
pouching163210412pouching
roaching143210432roaching
rogueing1054312rogueing
roguing9309562ro_guing
roughen11338832roughen_
roughening1543392roughening
roughens12286892roughens
roughies1298322roughies
roughish1545212roughish
roughleg1343402roughleg
rounding102812282rounding
rouping103715792rou_ping
rousing83920552rou_sing
rousting93913272rousting
routing83821092rou_ting
ruching133612932r_uching
rugging102512762r_ugging
rushing113817702r_ushing
sloughing14244752sloughing
southing122811822southing
sughing12359712_sughing
touching143211342touching
vouching17308232vouching
arousing93811803arou_sing
avouching1843273avouching
blushing14339333blushing
bogging123615753bo_gging
boggling13257163boggling
bonging113316373bong_ing
boogying1535373boogying
botching16359703botching
bouncing13318773bouncing
bounding123012133bounding
bousing103718043bou_sing
broaching17287663broaching
brushing14359963brushing
bugging123515183_bugging
bugling113615343_bugling
bushing134018583_bushing
chugging1634913chugging
coaching164011963coaching
cogging123513713co_gging
coigning1237173coigning
congaing1239823congaing
coshing134316433co_shing
couchings17285763couchings
counting113115273counting
couping124317023cou_ping
coupling13310783coupling
coursing113112023coursing
courting112514573courting
crushing143010053crushing
dodging11299063dodg_ing
dogging113312693do_gging
doubling1238153doubling
doubting1237373doubting
doughier1335483doughier
dousing93315763dou_sing
draughting1642883draughting
drouking1436443drou_king
drugging12326443drugging
flushing15288833flushing
fogging133513733fo_gging
forging124114723forg_ing
forgoing1366853forgoing
fouling113315373fou_ling
founding133010793founding
fraughting1843063fraughting
frogging14358733fro_gging
frothing15208533fro_thing
frouncing1534763frouncing
frugging14317053frugging
fugging133912913_fugging
fugling124212513_fugling
fuguing12337483_fuguing
furloughing1951053furloughing
gauging10339963gaug_ing
glugging10316353glugging
goggling10246283goggling
gonging103713033gong_ing
gorging102611363gorg_ing
grounding1236083grounding
grouping12308533grou_ping
grousing103410453grou_sing
grouting103410793grou_ting
gushing124014223_gushing
hogging133112803ho_gging
hongiing1335603hongiing
hotching17309313hotching
hounding132610053hounding
housing113316523hou_sing
hugging132710633_hugging
hushing144514473_hushing
jogging173211233jo_gging
joggling18215573joggling
joshing18519413jo_shing
jouking19307613jou_king
jouncing18336853jouncing
jousting16309353jousting
jugging172910723_jugging
kluging13356593klug_ing
laughings1443483laughings
loathing1247673loathing
lodging103110813lodg_ing
logging103316803lo_gging
longeing10177593longeing
longing93915783long_ing
lounging1036753lounging
louping104313983lou_ping
louring83916503lou_ring
lousing83817733lou_sing
louting83719383lou_ting
lugeing9359113_lugeing
lugging104114353_lugging
luging83915293_lug_ing
lushing114316113_lushing
mogging123311493mo_gging
mooching16259063mooching
morphing1637553morphing
moshing134214883mo_shing
moulding12258143moulding
moulting112710313moulting
mounding123311263mounding
mounting112711813mounting
mourning1156793mourning
mousing103816273mou_sing
moussing1138143moussing
mugging122711793_mugging
mushing134217633_mushing
neighing1355523neighing
nighing123410063_nighing
nogging103612723no_gging
northing12199063northing
noshing114612773no_shing
notching14288583notching
nothing113511903no_thing
ogling83211883_o_gling
ohing96018813_o__hing
ongoing938793_ongoing
oohing104412933_o_ohing
ousting84021353_ousting
outgoing1039273_outgoing
outing74128153_ou_ting
outring84021023_outring
outsing83320463_outsing
plugging13306893plugging
poaching163510833poaching
ponging113416153pong_ing
pooching16328983pooching
poohing133112323po_ohing
pouncing13318883pouncing
pounding123311473pounding
pouring103115863pou_ring
pouting103519943pou_ting
progging132610383pro_gging
pronging123511843prong_ing
pugging122912543_pugging
pushing133615453_pushing
ragging103516683r_agging
raging85126433r_ag_ing
ralphing1435413ralphing
ranching141712043ranching
ranging94120263rang_ing
reaching143317203reaching
refuging13218423refug_ing
reigning1039883reigning
repugning1335863repugning
retching143412173retching
retouching1644693retouching
reusing82516783reu_sing
ridging104112983ridg_ing
ridgling11258203ridgling
rigging103016333r_igging
righting132610853r_ighting
ringing93521283ring_ing
roaming103215793ro_aming
roaring82916003ro_aring
roasting93012703roasting
robbing123313213ro_bbing
robing93618003ro__bing
rocking143619633ro_cking
rockling15259383rockling
rodding103814533ro_dding
rodeoing1037253rodeoing
rogering10310273rogering
roiling83220453ro_iling
rolfing113710653ro_lfing
rolling83620413ro_lling
romping123113033ro_mping
roofing113814353ro_ofing
rooking123517363ro_oking
rooming104117043ro_oming
roosing84018133ro_osing
roosting93411463roosting
rooting83522433ro_oting
rootling9269953rootling
roping94023023ro__ping
roqueting1944603roqueting
rosing73925593ro__sing
rosining92411423rosining
rotating92614553rotating
rotting82919683ro_tting
rough97819433rough___
roughage1344423roughage
roughdry1692543roughdry
roughdrying205733roughdrying
roughed124210943rough_ed
roughened1444093roughened
rougher113511033rough_er
roughers12329183roughers
roughest1238773roughest
roughhew1842873roughhew
roughhewing2251013roughhewing
roughlegs1442583roughlegs
roughly14507293rough_ly
roughs105416213rough__s
roughy137010853rough__y
routine72615903rou_tine
roving103618743ro__ving
roweling122811123roweling
rowing103623303ro__wing
rubbing123412273r_ubbing
rubying13297933r_ubying
ruchings14287073r_uchings
rucking143216673r_ucking
ruffing143210843r_uffing
ruing67221053r_u__ing
ruining83514883r_uining
ruling73219553r_u_ling
running83514593r_unning
rushings12387843r_ushings
rusting83821263r_usting
rutting82718043r_utting
scrouging1335263scroug_ing
shushing15317743shushing
sighing123311663_sighing
slouching15195723slouching
slugging11339423slugging
slushing12299643slushing
smushing14287453smushing
snugging11286933snugging
soothing12269973soothing
souchong1484513souchong
sounding102712873sounding
souping104215533sou_ping
sourcing1158353sourcing
souring83219063sou_ring
sousing83517823sou_sing
southings13246233southings
togging103512743to_gging
toggling11206483toggling
tonging93314513tong_ing
tonguing1046263tonguing
toothing12278863toothing
torching142510083torching
toughen11329203toughen_
toughening1542913toughening
toughens12286723toughens
toughie1187593toughi_e
toughies1278243toughies
toughish1545283toughish
touring82915193tou_ring
tousing82916993tou_sing
tousling938793tousling
touting84118453tou_ting
touzling1835503touzling
trothing122410843tro_thing
troubling1234943troubling
trouncing1235153trouncing
trouping11249503trou_ping
tugging102611233_tugging
tushing114214013_tushing
vogueing1332233vogueing
voguing12296093vo_guing
waughting1743123waughting
weighing1635283weighing
wooshing1536683wooshing
worthing15178053worthing
wounding13249403wounding
wronging13327393wrong_ing
youngling1463273youngling

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622976.56022280.8
3Display Results2972970.1102700.0
 (SQL Overall)1786912977.07625253.1
 
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.