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

135 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
crutching1721607(None) 
clutching17154821clutching
crunching17297001crunching
grutching16224371grutching
brunching17316482brunching
catching163712772c_atching
churching2055082churching
couching163213262cou_ching
cranching17278732cranching
craunching1843312craunching
crouching1746382crouching
crushing143010052cru_shing
hutching17318642_hutching
retching143412172_retching
ruching133612932_ru_ching
scratching1844532scratching
scrunching18163472scrunching
scutching1735222scutching
smutching1734852smutching
arching136216693ar__ching
batching163712093_batching
bitching163610623_bitching
blotching1734963blotching
botching16359703_botching
branching17289263branching
breaching17269403breaching
breeching17236473breeching
broaching17287663broaching
brushing14359963bru_shing
bruting102612993brut__ing
bunching163410703_bunching
caching156317503c__aching
chucking20379503chu_cking
churchings2162553churchings
chuting132910733chut__ing
cinching163310223c_inching
clenching17266303clenching
clinching17276123clinching
clothing14278783clot_hing
clucking17429993clu_cking
coaching164011963c_oaching
couchings17285763cou_chings
coughing15309213cou_ghing
cracking174013903cr_acking
crashing143512633cr_ashing
cratering12312653cratering
crating103725203crat__ing
creeshing1536243creeshing
cricking173412653cr_icking
crocking174313443cr_ocking
crudding1335723cru_dding
cruising112610153cru_ising
crumbing15267813cru_mbing
crumbling1655083crumbling
crumping15319903cru_mping
crumpling1645323crumpling
crunchier1644683crunchier
crunchily1943193crunchily
crusading1344113crusading
crusting113612793cru_sting
crutch13408243crutch___
crutched16307463crutch_ed
crutches15359593crutch_es
curtsying1543813curtsying
cutting103817493c_ut_ting
cuttling1138203c_uttling
ditching15349943_ditching
douching15349843dou_ching
drenching16256033drenching
eructing112110173eru_cting
etching134511843__etching
fetching17298413_fetching
fletching18256143fletching
flitching18265343flitching
frenching18267753frenching
frothing15208533frot_hing
glunching16174083glunching
grouching1644943grouching
hatching173312213_hatching
hitching173310523_hitching
hotching17309313_hotching
hunching17309113_hunching
itching134011683__itching
kvetching2242903kvetching
latching143712023_latching
launching1544783launching
letching143810263_letching
lunching143110003_lunching
lurching14277333_lurching
matching163512393_matching
mouching163110583mou_ching
mouthing142810243mout_hing
mulching16287103_mulching
munching16299973_munching
notching14288583_notching
ouching134314903_ou_ching
patching163212753_patching
pitching163411113_pitching
pouching163210413pou_ching
preaching172811163preaching
punching163310123_punching
ranching141712043_ranching
reaching143317203_reaching
roaching143210433_roaching
ruchings14287073_ru_chings
rucking143216673_ru_cking
rushing113817703_ru_shing
rutting82718043_rut_ting
scootching1843363scootching
scotching1735653scotching
scraiching1843793scraiching
screeching1843643screeching
scrooching1843323scrooching
scrootching1951893scrootching
sketching1935083sketching
snatching1536363snatching
snitching1535913snitching
southing122811823sout_hing
stitching1547103stitching
stretching1645813stretching
switching1835703switching
thatching1835143thatching
touching143211343tou_ching
trenching15227653trenching
trithing122811773trit_hing
trothing122410843trot_hing
trucing103211843tru_c_ing
trucking153310163tru_cking
twitching1834243twitching
vouching17308233vou_ching
watching173011173_watching
witching173410633_witching
wrathing15248923wrat_hing
wrenching18276273wrenching
writhing15278673writ_hing

Search took 9 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 Limit1486411358.47017549.1
3Display Results1351350.0632142.9
 (SQL Overall)1786911358.96919923.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.