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 “branchiest” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
branchiest174671(None) 
beachiest1638442bea_chiest
branches153613802branch_es_
branchier1637132branchie_r
branchless1743302branchless
branchlet1647182branchle_t
branchlets1743802branchlets
branniest11199382bran_niest
brashiest14359852bra_shiest
bunchiest1635662b_unchiest
crunchiest1764792crunchiest
raunchiest1543932_raunchiest
achiest12315183__a_chiest
banshies131110663b_anshies_
barniest104815053barn__iest
beechiest1645003b_eechiest
bitchiest1636083b_itchiest
blanches153311603blanch_es_
blotchiest1743523blotchiest
botchiest1636153b_otchiest
bounciest1346433bounc_iest
braches144621223bra_ch_es_
brachet144020313bra_ch_e_t
brachets154311983bra_ch_ets
braggiest13116783bra_ggiest
brainiest11209723bra_iniest
brakiest143912243bra__kiest
brambliest1643773brambliest
branched163210453branch_e_d
branchia15217713branchi__a
branchiae16186313branchi_ae
branchial16215953branchi_al
branching17289263branchi_ng
branchlines1843613branchlines_
brandies11714563bran_dies_
brashest133511763bra_sh_est
brassiest11369713bra_ssiest
brattiest1148103bra_ttiest
brawliest14177193bra_wliest
brawniest14197103bra_wniest
breathiest1545993breathiest
brickiest1737433br_ickiest
briniest102812323brin__iest
bronziest2035813bron_ziest
brunches153710453brunch_es_
brushiest14297543br_ushiest
catchiest1638313_catchiest
chanciest1638373chanc_iest
chinchiest2044413chinchiest
cranches153114543cranch_es_
crankiest1538823cran_kiest
fanciest133612713_fanc_iest
franchise1746003franchi_se
franchised1943963franchised
franchisee1854453franchisee
franchiser1843623franchiser
franchises1855633franchises
grouchiest1644123grouchiest
leachiest1437243lea_chiest
orangiest1038463oran_giest
patchiest1638353_patchiest
paunchiest1743853paunchiest
peachiest1638523pea_chiest
poachiest1636883poa_chiest
preachiest1746983preachiest
punchiest1636453_punchiest
raciest92820013_ra_c_iest
ranches123620113_ranch_es_
ranchless1444453_ranchless
randiest93418773_ran_diest
rangiest93115983_ran_giest
reechiest1446013_reechiest
scratchiest1844143scratchiest
snatchiest1545143snatchiest
stanchest14218213stanch_est
starchiest1547183starchiest
stenchiest1545083stenchiest
thatchiest1844163thatchiest
tranches132915513tranch_es_
trashiest123110633tra_shiest
wrathiest1536973wra_thiest

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 Filter1786911406030.1731032896.0
2DLD Change Limit140603817.37319070.0
3Display Results81810.0801012.5
 (SQL Overall)178691817.62623431.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.