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

126 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
branchier163713(None) 
beachier1538802bea_chier
blancher15338632blanch_er
branched163210452branch_ed
branches153613802branch_es
branchia15217712branchi_a
branchiae16186312branchiae
branchial16215962branchial
branchiest1746712branchiest
branching17289262branching
branchlet1647182branchlet
brannier10218932bran_nier
brashier13389932bra_shier
bruncher15347782brunch_er
bunchier1536152b_unchier
crunchier1644682crunchier
franchiser1843622franchiser
rancher123013632_ranch_er
raunchier1443712_raunchier
achier113914263__a_chier
banshie12129543b_anshie_
banshies131110663b_anshies
barnier93213673barn__ier
batcher144414853b_atch_er
beechier1535633b_eechier
bencher144113483b_ench_er
bitchier15307733b_itchier
blanched16308603blanch_ed
blanchers16307433blanch_ers
blanches153311603blanch_es
blanching17297093blanching
blencher15308393blench_er
blotchier1643213blotchier
botchier15287143b_otchier
bouncier1236033bounc_ier
bracer104620583bra_c__er
braches144621223bra_ch_es
brachet144020313bra_ch_et
brachia141910423bra_chi_a
brachial15219303bra_chial
brachium1766113bra_chium
braggier12136453bra_ggier
brainchild1851973brainchild
brainier102510233bra_inier
brakier133812363bra__kier
bramblier1543503bramblier
branch134014773branch___
branchless1743303branchless
branchlets1743803branchlets
branchline1744123branchline
branchlines1843613branchlines
branchy17357913branch__y
brander103915823bran__der
brandied1259113bran_died
brandies11714563bran_dies
branner94212373bran__ner
brasher124515243bra_sh_er
brasier94516753bra__sier
brassier103310533bra_ssier
brattier1047663bra_ttier
brawlier13267043bra_wlier
brawnier13216723bra_wnier
brazier183911473bra__zier
breacher153011503breach_er
breathier1435383breathier
brickier16307163br_ickier
brinier93613473brin__ier
broacher15329263broach_er
bronchi14176313bronchi__
bronchia15195993bronchi_a
bronchial16175333bronchial
bronchium1843373bronchium
bronzier1935633bron_zier
brunched16317853brunch_ed
brunchers16296253brunch_ers
brunches153710453brunch_es
brunching17316483brunching
brushier13306973br_ushier
catchier15329863_catchier
chancier1538823chanc_ier
chinchier1944633chinchier
cranched163210413cranch_ed
cranches153114543cranch_es
cranching17278733cranching
crankier14339163cran_kier
cruncher15338073crunch_er
drencher14257213drench_er
fancier123412063_fanc_ier
franchise1746003franchise
franchised1943963franchised
franchisee1854453franchisee
franchisers1952813franchisers
franchises1855633franchises
franchisor1852613franchisor
grouchier1543843grouchier
leachier1337253lea_chier
orangier947713oran_gier
patchier15319663_patchier
paunchier1643333paunchier
peachier1548623pea_chier
poachier1556823poa_chier
prancer113613383pranc__er
preachier1646923preachier
punchier1536413_punchier
racier85120973_ra_c_ier
ranched133113603_ranch_ed
ranchero13277423_ranch_ero
ranchers133311793_ranch_ers
ranches123620113_ranch_es
ranching141712043_ranching
ranchmen1545833_ranchmen
randier83618473_ran_dier
rangier83714353_ran_gier
reechier1336673_reechier
scratchier1744343scratchier
snatchier1455353snatchier
stancher13198813stanch_er
starchier1436643starchier
stenchier1445333stenchier
thatchier1743983thatchier
tranche123312223tranch_e_
tranches132915513tranch_es
trashier113210103tra_shier
trencher13279313trench_er
wrathier1435903wra_thier
wrencher16287783wrench_er

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.420425454.8
2DLD Change Limit1486411266.94021418.0
3Display Results1261260.0602100.0
 (SQL Overall)1786911267.42024082.3
 
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.