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

175 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
cranching1727873(None) 
branching17289261branching
craunching1843311craunching
crunching17297001crunching
ranching141712041_ranching
blanching17297092blanching
brunching17316482brunching
caching156317502c_a_ching
catching163712772c_atching
chancing162810282chanc_ing
cinching163310222c_inching
clenching17266302clenching
clinching17276122clinching
coaching164011962coa_ching
cracking174013902cra_cking
craning103620302cran__ing
cranking154613072cran_king
crankling16147292crankling
crashing143512632cra_shing
crouching1746382crouching
crutching17216072crutching
drenching16256032drenching
frenching18267752frenching
prancing132612162pranc_ing
scraiching1843792scraiching
scratching1844532scratching
scrunching18163472scrunching
stanching1538082stanching
trancing112812022tranc_ing
trenching15227652trenching
wrenching18276272wrenching
aching126521973__a_ching
arching136216693__arching
baching156017753_ba_ching
batching163712093_batching
beaching164114143bea_ching
benching163411343_benching
blenching17276503blenching
bracing123817613bra_c_ing
branchia15217713branchi_a
branchiae16186313branchiae
branchial16215963branchial
branchier1637133branchier
branchline1744123branchline
branding122513683bran_ding
brandling1348253brandling
brandying1654883brandying
branning112911093bran_ning
breaching17269403breaching
breeching17236473breeching
broaching17287663broaching
bunching163410703_bunching
canaling112016413c_analing
canceling14310163c_anceling
candling122313873c_andling
candying15188993c_andying
caning94128623c_an__ing
canning103620133c_an_ning
canoeing11310213c_anoeing
canting104725903c_an_ting
cashing135022553c_a_shing
changing153211513chan_ging
chanting143413533chan_ting
churching2055083churching
clacking173313493cla_cking
clanging124012123clan_ging
clanking154313063clan_king
clashing143812193cla_shing
clutching17154823clutching
coacting133412703coa_cting
coanchoring1943243coanchoring
couching163213263c_ouching
craaling112711353cra_aling
crabbing15287933cra_bbing
crackings18346843cra_ckings
crackling18157003crackling
cradling122411453cra_dling
crafting143710173cra_fting
cramming15339433cra_mming
cramping153411853cra_mping
cranch133613533cranch___
cranched163210413cranch_ed
cranches153114543cranch_es
crankpin16103753crankpin_
crankpins17133763crankpins
craping124018713cra__ping
crapping153911453cra_pping
cratering12312653cratering
crating103725203cra__ting
cravening1547553cravening
craving134015733cra__ving
crawling143110513cra_wling
crayoning1535243crayoning
crazing193914583cra__zing
creeshing1536243creeshing
creneling1247733creneling
cricking173412653cr_icking
cringing123311383crin_ging
crinkling16145863crinkling
crocking174313443cr_ocking
crunchier1644683crunchier
crunchily1943193crunchily
crushing143010053cr_ushing
cyaniding1644803cyaniding
dancing113611563_danc_ing
fancying1735353_fancying
flenching18296703flenching
flinching18245833flinching
franchise1746003franchise
franchising2053843franchising
francizing2545373francizing
franking164310863fran_king
glancing1247063glanc_ing
glunching16174083glunching
gracing113216443gra_c_ing
granting103514523gran_ting
graphing1538533gra_phing
grouching1644943grouching
grutching16224373grutching
hatching173312213_hatching
hunching17309113_hunching
inarching1546343inarching
inching134414323__inching
lancing103314123_lanc_ing
latching143712023_latching
launching1544783launching
leaching143012833lea_ching
lunching143110003_lunching
lynching17336083_lynching
marching164312193_marching
matching163512393_matching
munching16299973_munching
parching164313053_parching
patching163212753_patching
peaching163613643pea_ching
pinching163711053_pinching
poaching163510833poa_ching
pranging123012723pran_ging
pranking153813383pran_king
preaching172811163preaching
punching163310123_punching
quenching2443923quenching
racing95030533_ra_c_ing
racking144323663_ra_cking
ralphing1435413_ralphing
ranging94120263_ran_ging
ranking124320883_ran_king
rankling132610113_rankling
ranting84025413_ran_ting
reaching143317203_reaching
rebranching1943383rebranching
retching143412173_retching
roaching143210433_roaching
ruching133612933_r_uching
scraighing1742933scraighing
screeching1843643screeching
scrooching1843323scrooching
searching1538343searching
snatching1536363snatching
starching1538593starching
staunching1643213staunching
synching17227713_synching
teaching143612603tea_ching
thatching1835143thatching
trachling1537823tra_chling
tracing103720153tra_c_ing
tracking153715463tra_cking
trashing122613223tra_shing
trauchling1643473trauchling
watching173011173_watching
wenching17328863_wenching
winching17359903_winching
wracking18349963wra_cking
wrangling1456223wrangling
wrathing15248923wra_thing

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 Limit1486411757.07621006.4
3Display Results1751750.0802187.5
 (SQL Overall)1786911757.57923577.1
 
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.