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

380 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
ranching14171204(None) 
branching17289261branching
cranching17278731cranching
aching126521972_a_ching
arching136216692_arching
baching156017752ba_ching
batching163712092batching
benching163411342benching
blanching17297092blanching
brunching17316482brunching
bunching163410702bunching
caching156317502ca_ching
catching163712772catching
cinching163310222cinching
craunching1843312craunching
crunching17297002crunching
dancing113611562danc_ing
drenching16256032drenching
fancying1735352fancying
frenching18267752frenching
hatching173312212hatching
hunching17309112hunching
inching134414322_inching
lancing103314122lanc_ing
latching143712022latching
launching1544782launching
lunching143110002lunching
lynching17336082lynching
marching164312192marching
matching163512392matching
munching16299972munching
parching164313052parching
patching163212752patching
pinching163711052pinching
prancing132612162pranc_ing
punching163310122punching
racing95030532ra_c_ing
racking144323662ra_cking
ralphing1435412ralphing
ranging94120262ran_ging
ranking124320882ran_king
rankling132610112rankling
ranting84025412ran_ting
reaching143317202reaching
retching143412172retching
roaching143210432roaching
ruching133612932r_uching
stanching1538082stanching
synching17227712synching
trancing112812022tranc_ing
trenching15227652trenching
watching173011172watching
wenching17328862wenching
winching17359902winching
wrenching18276272wrenching
aahing1019015763_a_ahing
acing87429153_a_c_ing
acting95920983_a_cting
ahing98928353_a__hing
anchoring1548323_anchoring
aneling82719503_aneling
angling92816043_angling
anhinga11104823_an_hinga
ankling122912063_ankling
anteing8312813_anteing
anting75827023_an_ting
anything1534993_anything
archine125817053_archine
archings14499863_archings
arcing95819643_arc_ing
arcking145811963_arcking
ashing107824093_a_shing
backing165523443ba_cking
banding114921413ban_ding
bandying15218073bandying
banging114019863ban_ging
baning95127833ban__ing
banishing1537143banishing
banking144621353ban_king
banning103818233ban_ning
bantling112612003bantling
bashing135422583ba_shing
bathing134816243ba_thing
beaching164114143beaching
belching16349153belching
birching16328463birching
bitching163610623bitching
blenching17276503blenching
botching16359703botching
bracing123817613bra_c_ing
branchia15217713branchi_a
branchiae16186313branchiae
branchial16215953branchial
branchier1637133branchier
branchline1744123branchline
branding122513683bran_ding
brandling1348253brandling
brandying1654883brandying
branning112911093bran_ning
breaching17269403breaching
breeching17236473breeching
broaching17287663broaching
buncoing13337813buncoing
canaling112016413canaling
canceling14310163canceling
candling122313873candling
candying15188993candying
caning94128623can__ing
canning103620133can_ning
canoeing11310213canoeing
canting104725903can_ting
cashing135022553ca_shing
chancing162810283chanc_ing
clenching17266303clenching
clinching17276123clinching
coaching164011963coaching
couching163213263couching
cracking174013903cra_cking
craning103620303cran__ing
cranking154613073cran_king
crankling16147293crankling
crashing143512633cra_shing
crouching1746383crouching
crutching17216073crutching
dandling112511733dandling
danging103716093dan_ging
dangling112611233dangling
dashing125917893da_shing
ditching15349943ditching
douching15349843douching
eanling81416673ean_ling
earthing12310323earthing
eching126315563__eching
enacting11311363enacting
etching134511843_etching
facing125321573fa_c_ing
faithing1537153faithing
fanning113615073fan_ning
farcing133514003farc_ing
farthing1538073farthing
fashing144918793fa_shing
fencing132411133fenc_ing
fetching17298413fetching
filching1736113filching
flenching18296703flenching
flinching18245833flinching
franchise1746003franchise
franchising2053843franchising
francizing2545373francizing
franking164310863fran_king
ganging103216193gan_ging
gangling112411403gangling
gashing125119233ga_shing
glancing1247063glanc_ing
glunching16174083glunching
gnashing1336423gnashing
gracing113216443gra_c_ing
granting103514523gran_ting
graphing1538533gra_phing
grouching1644943grouching
grutching16224373grutching
hacking173720613ha_cking
handing123518893han_ding
handling132312713handling
hanging123518703han_ging
hanking154619103han_king
hanting114124483han_ting
hashing145020163ha_shing
hatchings18225673hatchings
hatchling1844953hatchling
hitching173310523hitching
honchoing1844873honchoing
hotching17309313hotching
hutching17318643hutching
inarching1546343inarching
itching134011683_itching
jacking214515263ja_cking
jangling17249623jangling
jauncing18314783jaunc_ing
kachina1637663ka_china
katchina1745333katchina
knacking14296713knacking
lacing94626233la_c_ing
lacking143821543la_cking
landing92819323lan_ding
lashing114422893la_shing
lathing114315693la_thing
laughing1335933laughing
leaching143012833leaching
leching134613653_leching
leeching14318373leeching
letching143810263letching
lurching14277333lurching
lynchings18233503lynchings
machine14313493ma_chine
macing114221553ma_c_ing
manacling1446283manacling
managing1239093managing
mangling122312623mangling
manning103616383man_ning
mantling112012613mantling
manuring1139223manuring
mashing134422243ma_shing
miching152911803_miching
mincing123314333minc_ing
mooching16259063mooching
mouching163110583mouching
mulching16287103mulching
naething1236073naething
niching133612433_niching
noncling11310763noncling
notching14288583notching
ouching134314903_ouching
pacing114522753pa_c_ing
packing164420723pa_cking
pancaking1836383pancaking
pandying15217663pandying
paneling111013623paneling
panging113319113pan_ging
panicking1835293panicking
panning104019393pan_ning
panting104025423pan_ting
pashing135120513pa_shing
peaching163613643peaching
peching154513903_peching
perching163711633perching
pitching163411113pitching
poaching163510833poaching
poncing122913583ponc_ing
pooching16328983pooching
pouching163210413pouching
pranging123012723pran_ging
pranking153813383pran_king
preaching172811163preaching
psyching1934483psyching
quenching2443923quenching
rabbling13239333rabbling
racheting1537793ra_cheting
rachial122012173ra_chial
rachis114017653ra_chi_s
racings105015133ra_c_ings
radding103715003ra_dding
raddling11229773raddling
radioing1039383radioing
raffling1567063raffling
rafting113815753ra_fting
ragging103516683ra_gging
raging85126433ra__ging
raiding93617593ra_iding
railing83325643ra_iling
raining83922693ra_ining
raising83220533ra_ising
raking114728423ra__king
rallying12289013rallying
rambling131810773rambling
ramming123115063ra_mming
ramping123316873ra_mping
ranch105019793ranch___
ranched133113603ranch_ed
rancher123013633ranch_er
ranchero13277423ranchero
ranchers133311793ranchers
ranches123620113ranch_es
ranchlike1844083ranchlike
ranchman1546043ranchman
ranchmen1545833ranchmen
rancho114310853ranch__o
ranchos123911393ranch_os
rancid9513863ranc_i_d
rankings13389173ran_kings
ransacking1744423ransacking
ransoming1256513ransoming
raping94829853ra__ping
rapping123619103ra_pping
raring74332873ra__ring
rasing74330833ra__sing
rasping104316253ra_sping
rassling939013rassling
ratcheting1643783ratcheting
rating74938703ra__ting
ratting83822363ra_tting
rattling92510873rattling
raunchier1443713raunchier
raunchily1742813raunchily
ravaging1346323ravaging
raveling123414373raveling
ravening122611293ravening
raving105128853ra__ving
ravining12269693ravining
ravishing1634983ravishing
raxing144321023ra__xing
raying105027193ra__ying
razeeing1834363razeeing
razing164524543ra__zing
razoring1836443razoring
razzing1636323ra_zzing
reacting113317893reacting
rebranching1943383rebranching
recking144319923r_ecking
reechoing1545293reechoing
relaunching1742243relaunching
rematching1844913rematching
renaming11313693renaming
rending93924263ren_ding
reneging102111533reneging
renewing121910713renewing
renting84026853ren_ting
repatching1844993repatching
rescuing1139623rescuing
ricing94822763r_ic_ing
ricking143920233r_icking
ringing93521283rin_ging
rinning83216743rin_ning
rinsing82516113rin_sing
rocking143619633r_ocking
romancing1446043romanc_ing
roughing13278343roughing
ruchings14287073r_uchings
rucking143216673r_ucking
runkling13217613runkling
running83514593run_ning
rushing113817703r_ushing
sacking144122703sa_cking
sacring103115983sa_cring
sanding93520603san_ding
sandling102214413sandling
saning75127643san__ing
sashing114621473sa_shing
saucing10311003sauc_ing
scraiching1843793scraiching
scratching1844533scratching
scrunching18163473scrunching
searching1538343searching
snacking153411703snacking
snatching1536363snatching
starching1538593starching
staunching1643213staunching
syncing13177223sync_ing
tacking144421483ta_cking
talcing103111633talc_ing
talcking1567083talcking
tanging93419523tan_ging
tangling101712543tangling
tangoing10177893tangoing
tanking123918793tan_king
tanning83618253tan_ning
teaching143612603teaching
thatching1835143thatching
tincting1148883tincting
torching142510083torching
touching143211343touching
trachling1537823tra_chling
tracing103720153tra_c_ing
tracking153715463tra_cking
trashing122613223tra_shing
trauchling1643473trauchling
vanishing1646303vanishing
vanning113912463van_ning
vouching17308233vouching
wangling132310993wangling
waning103623803wan__ing
wanking154216783wan_king
wanning113816213wan_ning
wanting114220173wan_ting
washing145119283wa_shing
wauchting1843473wauchting
welching17287363welching
wincing133413903winc_ing
witching173410633witching
wracking18349963wra_cking
wrangling1456223wrangling
wrathing15248923wra_thing
xanthin1747043xanthin_
xanthine1847253xanthine
xanthins1846943xanthins
yachting1734933ya_chting
yacking174315683ya_cking
yanking154512463yan_king
zincing192910283zinc_ing
zincking2435463zincking

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.1701051123.5
2DLD Change Limit1461623808.40617387.8
3Display Results3803800.1432657.3
 (SQL Overall)1786913808.71920494.4
 
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.