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

356 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
catching16371277(None) 
batching163712091batching
caching156317501ca_ching
hatching173312211hatching
latching143712021latching
matching163512391matching
patching163212751patching
watching173011171watching
aching126521972_a_ching
arching136216692_arching
baching156017752ba_ching
bathing134816242bat_hing
bitching163610622bitching
botching16359702botching
cashing135022552ca_shing
catchier15329862catchier
catechin1546812catechin_
catechins1646642catechins
catering112019902catering
catling104819792cat_ling
catting103922642cat_ting
cinching163310222cinching
clutching17154822clutching
coaching164011962coaching
couching163213262couching
cranching17278732cranching
crutching17216072crutching
ditching15349942ditching
etching134511842_etching
fetching17298412fetching
hatchings18225672hatchings
hatchling1844952hatchling
hitching173310522hitching
hotching17309312hotching
hutching17318642hutching
itching134011682_itching
katchina1745332katchina
lathing114315692lat_hing
letching143810262letching
marching164312192marching
notching14288582notching
parching164313052parching
pitching163411112pitching
ranching141712042ranching
retching143412172retching
scathing14269702scat_hing
scotching1735652scotching
scratching1844532scratching
scutching1735222scutching
snatching1536362snatching
thatching1835142thatching
witching173410632witching
aahing1019015763_a_ahing
acing87429153_a_c_ing
acting95920983_a_cting
ahing98928353_a__hing
archine125817053_archine
archings14499863_archings
arcing95819643_arc_ing
arcking145811963_arcking
ashing107824093_a_shing
atoning83514873_atoning
attaching1545433attaching
backing165523443ba_cking
bashing135422583ba_shing
batiking1537503batiking
bating95132253bat__ing
batting104422273bat_ting
battling113110493battling
batwing13509813bat_wing
beaching164114143beaching
belching16349153belching
benching163411343benching
birching16328463birching
blanching17297093blanching
blotching1734963blotching
branching17289263branching
bunching163410703bunching
cabbing143613153ca_bbing
cabining1338643cabining
cabling124017553ca_bling
cacheting1737153ca_cheting
cackling172610943cackling
caddying16225063caddying
cadging123610973ca_dging
cageling12310843cageling
caging105321023ca__ging
cajoling18318423cajoling
caking134624673ca__king
calcine11315273calc_ine
calcining1447813calcining
calking144617783ca_lking
calling103826773ca_lling
calming123915973ca_lming
calquing2035593calquing
calving134113503ca_lving
cameoing1379063cameoing
camphine1738373camphine
camping143118973ca_mping
canaling112016413canaling
canceling14310163canceling
candling122313873candling
candying15188993candying
caning94128623ca__ning
canning103620133ca_nning
canoeing11310213canoeing
cantering122417373cantering
canting104725903ca_nting
cantoning12310883cantoning
capering132414963capering
capping143819673ca_pping
capturing1436623capturing
capuchin1743673capuchin_
capuchins1843373capuchins
carding113922443ca_rding
caring95137993ca__ring
carking144322853ca_rking
carling103727063ca_rling
caroling113317003caroling
caroming133312963caroming
carping123521083ca_rping
carrying14148373carrying
carting104228283ca_rting
cartoning12311113cartoning
carving133916773ca_rving
cascading1545673cascading
casing94829103ca__sing
casking144317353ca_sking
casting104628343ca_sting
castling11311233castling
catcalling1545123catcalling
catch125120373catch___
catchall1546233catchall
catcher143115823catch_er
catchers153114063catchers
catches144320773catch_es
catchfly2143333catchfly
catchiest1638313catchiest
catchment1846293catchment
catchup1644793catch_up
catchups1744383catchups
catchy16559583catch__y
catechise1644943catechise
catechising1953543catechising
catechism1844723catechism
catechist1656803catechist
catechize2544473catechize
catechizing2853973catechizing
catfacing1744553catfacing
cathecting1844833cathecting
catjang1733923cat_jang
catkin123512383cat_kin_
catkins133012563cat_kins
catlin83819083cat_lin_
catlings113712043cat_lings
catlins93818843cat_lins
catmint11314463cat_mint
caucusing1443803caucusing
caulking1536803caulking
causing103614413ca_using
caviling14310113caviling
caving124822613ca__ving
cawing124322613ca__wing
chancing162810283chanc_ing
chatting142810143chat_ting
checking20379203checking
chocking204011013chocking
chucking20379503chucking
churching2055083churching
circling1338423circling
citing94220183cit__ing
clacking173313493clacking
clashing143812193clashing
clenching17266303clenching
clicking173610983clicking
clinching17276123clinching
clocking174312413clocking
clothing14278783clothing
clucking17429993clucking
coacting133412703coacting
coating103525313coat__ing
cochin131313203c_ochin_
cochins141413103c_ochins
cocking163619983c_ocking
coshing134316433c_oshing
coting94629253cot__ing
couchings17285763couchings
coughing15309213coughing
cracking174013903cracking
crashing143512633crashing
cratering12312653cratering
crating103725203crat__ing
craunching1843313craunching
cricking173412653cricking
crocking174313443crocking
crouching1746383crouching
crunching17297003crunching
crushing143010053crushing
cutting103817493cut_ting
cuttling1138203cuttling
cycling1537213c_ycling
dancing113611563danc_ing
dashing125917893da_shing
dating85326483dat__ing
detaching1637263detaching
douching15349843douching
earthing12310333earthing
eating75134403eat__ing
eching126315563__eching
etchings14396293_etchings
facing125321573fa_c_ing
faithing1537153faithing
fancying1735353fancying
farcing133514003farc_ing
farthing1538073farthing
fashing144918793fa_shing
fating105328673fat__ing
fatling113815683fat_ling
fatting113818703fat_ting
filching1736113filching
fletching18256143fletching
flitching18265343flitching
gashing125119233ga_shing
gating84826953gat__ing
grutching16224373grutching
hacking173720613ha_cking
hashing145020163ha_shing
hatcheling1943693hatcheling
hatchlings1943033hatchlings
hating104929713hat__ing
hatting113920233hat_ting
hunching17309113hunching
inarching1546343inarching
inching134414323_inching
itchings14386193_itchings
jacking214515263ja_cking
kachina1637663ka_china
katchinas1843923katchinas
katcina1345153katc_ina
kithing153411553kit_hing
kvetching2242903kvetching
kything18285523kyt_hing
lacing94626233la_c_ing
lacking143821543la_cking
lancing103314123lanc_ing
lashing114422893la_shing
latening9711493latening
lathings12469853lat_hings
laughing1335933laughing
launching1544783launching
leaching143012833leaching
leching134613653_leching
leeching14318373leeching
loathing1247673loat_hing
lunching143110003lunching
lurching14277333lurching
lynching17336083lynching
machine14313493ma_chine
macing114221553ma_c_ing
mashing134422243ma_shing
mating94832913mat__ing
matting103620143mat_ting
maturing1139963maturing
miching152911803_miching
mooching16259063mooching
mouching163110583mouching
mulching16287103mulching
munching16299973munching
naething1236073naething
niching133612433_niching
nothing113511903not_hing
ouching134314903_ouching
outcatching1943113outcatching
pacing114522753pa_c_ing
packing164420723pa_cking
pashing135120513pa_shing
patchier15319663patchier
patchily1885813patchily
patining11312303patining
patting103722343pat_ting
peaching163613643peaching
peching154513903_peching
perching163711633perching
pinching163711053pinching
pithing134014053pit_hing
poaching163510833poaching
pooching16328983pooching
pouching163210413pouching
psyching1934483psyching
punching163310123punching
racing95030533ra_c_ing
racking144323663ra_cking
ralphing1435413ralphing
ratcheting1643783ratcheting
rating74938703rat__ing
ratting83822363rat_ting
rattling92510873rattling
reaching143317203reaching
rematching1844913rematching
repatching1844993repatching
roaching143210433roaching
ruching133612933_ruching
sacking144122703sa_cking
sacring103115983sa_cring
sashing114621473sa_shing
sating74735453sat__ing
saucing10311003sauc_ing
scarphing1735243scarphing
scatting113311813scat_ting
scooching1735073scooching
scootching1843363scootching
scorching1735633scorching
scraiching1843793scraiching
scything17264883scyt_hing
searching1538343searching
sketching1935083sketching
smutching1734853smutching
snitching1535913snitching
stacking154215083stacking
stanching1538083stanching
starching1538593starching
stashing123511583stashing
stitching1547103stitching
swathing15248713swat_hing
switching1835703switching
synching17227713synching
tacking144421483ta_cking
talcing103111633talc_ing
talcking1567083talcking
tatting84019523tat_ting
tattling9259473tattling
teaching143612603teaching
thatchings1942483thatchings
thing96622983__t_hing
tithing113513893tit_hing
torching142510083torching
touching143211343touching
twitching1834243twitching
tything14316573tyt_hing
unlatching1643153unlatching
vatting113614853vat_ting
vetchling1843593vetchling
vouching17308233vouching
washing145119283wa_shing
watchdog1842243watchdog
watering122316313watering
wattling12258783wattling
wauchting1843473wauchting
welching17287363welching
wenching17328863wenching
winching17359903winching
witchings18325303witchings
withing143814493wit_hing
wrathing15248923wrat_hing
yachting1734933ya_chting
yacking174315683ya_cking

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 Filter1786911461620.453394461.4
2DLD Change Limit1461623567.92318447.8
3Display Results3563560.1532326.8
 (SQL Overall)1786913568.52920951.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.