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

158 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
crouching174638(None) 
couching163213261c_ouching
grouching1644941grouching
avouching1843272avouching
broaching17287662broaching
coaching164011962c_oaching
couchings17285762c_ouchings
coughing15309212c_oughing
cranching17278732cranching
craunching1843312craunching
crocking174313442cro_cking
crunching17297002crunching
crushing143010052cr_ushing
crutching17216072crutching
douching15349842_douching
mouching163110582_mouching
ouching134314902__ouching
pouching163210412_pouching
roaching143210432_roaching
roughing13278342_roughing
ruching133612932_r_uching
scrooching1843322scrooching
slouching15195722slouching
touching143211342_touching
vouching17308232_vouching
arching136216693ar__ching
arousing93811803arou_sing
blotching1734963blotching
botching16359703_botching
branching17289263branching
breaching17269403breaching
breeching17236473breeching
brunching17316483brunching
brushing14359963br_ushing
caching156317503c__aching
capuchin1743673capuchin_
capuchins1843373capuchins
carousing1237893carou_sing
catching163712773c_atching
chocking204011013cho_cking
chousing14259423chou_sing
chucking20379503c_hucking
churching2055083churching
cinching163310223c_inching
clenching17266303clenching
clinching17276123clinching
clocking174312413clo_cking
clothing14278783clo_thing
clouding12269493clou_ding
clouring112811273clou_ring
clouting113011683clou_ting
clucking17429993c_lucking
clutching17154823clutching
coacting133412703c_oacting
cochin131313203c_o_chin_
cochins141413103c_o_chins
cocking163619983c_o_cking
coshing134316433c_o_shing
couchant1549053c_ouchant
counting113115273c_ounting
couping124317023c_ou_ping
coupling13310783c_oupling
coursing113112023c_oursing
courting112514573c_ourting
cracking174013903cr_acking
crashing143512633cr_ashing
creeshing1536243creeshing
cricking173412653cr_icking
croaking153712163cro_aking
crocein1138073cro_cein_
croceine1248033cro_ceine
croceins1238103cro_ceins
crocheting1844703cro_cheting
crocine11314153cro_c_ine
crooking153611343cro_oking
crooning113112113cro_oning
cropping153210883cro_pping
croqueting2243173croqueting
crossing112612683cro_ssing
crouch133910203crouch___
crouched16359143crouch_ed
crouches153711293crouch_es
crowding15247933cro_wding
crowing133814763cro__wing
crowning143510033cro_wning
crudding1335723cr_udding
cruising112610153cr_uising
crumbing15267813cr_umbing
crumping15319903cr_umping
crusting113612793cr_usting
debouching1942723debouching
drenching16256033drenching
drouking1436443drou_king
encroaching1942993encroaching
eructing112110173er_ucting
frenching18267753frenching
frocking18309573fro_cking
frothing15208533fro_thing
frouncing1534763frouncing
grouchier1543843grouchier
grouchily1842843grouchily
grounding1236083grounding
grouping12308533grou_ping
grousing103410453grou_sing
grouting103410793grou_ting
grutching16224373grutching
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
scootching1843363scootching
scorching1735633scorching
scotching1735653scotching
scraiching1843793scraiching
scratching1844533scratching
screeching1843643screeching
scrootching1951893scrootching
scrouging1335263scrou_ging
scrounging1443353scrounging
scrunching18163473scrunching
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.423422437.4
2DLD Change Limit1486411587.31320325.6
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.79922912.0
 
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.