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

126 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
grouching164494(None) 
crouching1746381crouching
avouching1843272avouching
broaching17287662broaching
couching163213262_couching
douching15349842_douching
grouchier1543842grouchier
grouchily1842842grouchily
grounding1236082grounding
grouping12308532grou_ping
grousing103410452grou_sing
grouting103410792grou_ting
grutching16224372grutching
mouching163110582_mouching
ouching134314902__ouching
pouching163210412_pouching
roaching143210432_roaching
roughing13278342_roughing
ruching133612932_r_uching
slouching15195722slouching
touching143211342_touching
vouching17308232_vouching
arching136216693ar__ching
arousing93811803arou_sing
blotching1734963blotching
botching16359703_botching
branching17289263branching
breaching17269403breaching
breeching17236473breeching
brunching17316483brunching
brushing14359963br_ushing
coaching164011963_coaching
couchings17285763_couchings
coughing15309213_coughing
cranching17278733cranching
craunching1843313craunching
crocking174313443cro_cking
crunching17297003crunching
crushing143010053cr_ushing
crutching17216073crutching
debouching1942723debouching
drenching16256033drenching
drouking1436443drou_king
eructing112110173er_ucting
frenching18267753frenching
frocking18309573fro_cking
frothing15208533fro_thing
frouncing1534763frouncing
glouting10379693glou_ting
glunching16174083glunching
gouging103410703g_ou_ging
gracing113216443gr_ac_ing
graphing1538533gr_aphing
groaning102410283gro_aning
groining102310633gro_ining
grokking1334813gro_kking
grooming12309513gro_oming
grooving13286713gro_oving
groping113313103gro__ping
groschen1442973groschen_
grossing103111063gro_ssing
grouch12318473grouch___
grouched15356663grouch_ed
grouches14328213grouch_es
grouchiest1644123grouchiest
grouchiness1742763grouchiness
grouchy16294243grouch__y
groundings1343743groundings
groundling1343393groundling
groupings13273813grou_pings
groupthink205993groupthink
groveling1435573groveling
growing123512473gro__wing
growling1348163gro_wling
grubbing14295403gr_ubbing
grudging12255993gr_udging
grueling1078273gr_ueling
gruffing1635273gr_uffing
grumping14266903gr_umping
grunting10269583gr_unting
gushing124014223g__ushing
hotching17309313_hotching
mooching16259063_mooching
mouthing142810243_mouthing
notching14288583_notching
ploughing16203673ploughing
poaching163510833_poaching
pooching16328983_pooching
preaching172811163preaching
procuring1437993procuring
producing1556143produc_ing
ranching141712043_ranching
reaching143317203_reaching
retching143412173_retching
retouching1644693retouching
rocking143619633_ro_cking
rouging93114703_rou_ging
rounding102812283_rounding
rouping103715793_rou_ping
rousing83920553_rou_sing
rousting93913273_rousting
routing83821093_rou_ting
ruchings14287073_r_uchings
rucking143216673_r_ucking
rushing113817703_r_ushing
scooching1735073scooching
scorching1735633scorching
scotching1735653scotching
scrooching1843323scrooching
sloughing14244753sloughing
smooching1734883smooching
souchong1484513_souchong
soughing13259733_soughing
southing122811823_southing
torching142510083_torching
toughing13278553_toughing
trauchling1643473trauchling
trenching15227653trenching
trocking153612423tro_cking
trothing122410843tro_thing
troubling1234943troubling
trouncing1235153trouncing
trouping11249503trou_ping
trucing103211843tr_uc_ing
trucking153310163tr_ucking
wrenching18276273wrenching

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411266.92321470.6
3Display Results1261260.0632000.0
 (SQL Overall)1786911267.42224075.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.