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

190 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
branching1728926(None) 
blanching17297091blanching
brunching17316481brunching
cranching17278731cranching
ranching141712041_ranching
baching156017752b_a_ching
batching163712092b_atching
beaching164114142bea_ching
benching163411342b_enching
blenching17276502blenching
bracing123817612bra_c_ing
branchia15217712branchi_a
branchiae16186312branchiae
branchial16215962branchial
branchier1637132branchier
branchline1744122branchline
branding122513682bran_ding
brandling1348252brandling
brandying1654882brandying
branning112911092bran_ning
breaching17269402breaching
breeching17236472breeching
broaching17287662broaching
bunching163410702b_unching
craunching1843312craunching
crunching17297002crunching
drenching16256032drenching
frenching18267752frenching
prancing132612162pranc_ing
rebranching1943382rebranching
stanching1538082stanching
trancing112812022tranc_ing
trenching15227652trenching
wrenching18276272wrenching
aching126521973__a_ching
arching136216693__arching
backing165523443b_a_cking
balancing1435783balanc_ing
banding114921413b_an_ding
bandying15218073b_andying
banging114019863b_an_ging
baning95127833b_an__ing
banishing1537143b_anishing
banking144621353b_an_king
banning103818233b_an_ning
bantling112612003b_antling
barning104320353barn__ing
bashing135422583b_a_shing
bathing134816243b_a_thing
beaning103820683bean__ing
bedrenching2052273bedrenching
belching16349153b_elching
birching16328463b_irching
bitching163610623b_itching
blacking174213603bla_cking
blanking154411933blan_king
bleaching17287093bleaching
blotching1734963blotching
botching16359703b_otching
bouncing13318773bounc_ing
brabbling1334963brabbling
brachia141910423bra_chi_a
brachial15219303bra_chial
brachium1766113bra_chium
bracings13369293bra_c_ings
bradding13268933bra_dding
bragging13359333bra_gging
braiding123112703bra_iding
brailing113514793bra_iling
brailling1247773brailling
brainchild1851973brainchild
braining113414683bra_ining
braising113014563bra_ising
braking143917713bra__king
brambling1635543brambling
branch134014773branch___
branched163210453branch_ed
branches153613803branch_es
branchiest1746713branchiest
branchlet1647183branchlet
branchlines1843613branchlines
branchy17357913branch__y
brandings13277483bran_dings
brandishing1853363brandishing
brandlings1443993brandlings
brassing112612303bra_ssing
brattling1236003brattling
braving133714613bra__ving
bravoing1445993bra_voing
brawling143210043bra_wling
braying134416313bra__ying
brazening2185183brazening
brazing193715113bra__zing
breathing15218373breathing
breechings18273723breechings
bricking173911403br_icking
bringing123011273brin_ging
brining103216473brin__ing
bronchi14176313bronchi__
bronchia15195993bronchi_a
bronchial16175333bronchial
bronchium1843373bronchium
bronzing2037693bron_zing
brushing14359963br_ushing
buncoing13337813b_uncoing
caching156317503_ca_ching
catching163712773_catching
chancing162810283chanc_ing
cinching163310223_cinching
clenching17266303clenching
clinching17276123clinching
coaching164011963coa_ching
cracking174013903cra_cking
craning103620303cran__ing
cranking154613073cran_king
crankling16147293crankling
crashing143512633cra_shing
crouching1746383crouching
crutching17216073crutching
dancing113611563_danc_ing
disbranching2152483disbranching
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
retching143412173_retching
roaching143210433_roaching
ruching133612933_r_uching
scraiching1843793scraiching
scratching1844533scratching
scrunching18163473scrunching
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.1561145455.1
2DLD Change Limit1486411907.22020587.4
3Display Results1901900.0932043.0
 (SQL Overall)1786911907.46923924.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.