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

75 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
branchia1521771(None) 
brachia141910421bra_chia
branchiae16186311branchiae
branchial16215951branchial
bronchia15195991bronchia
abrachia1545842abra_chia
brachial15219302bra_chial
branch134014772branch__
branched163210452branched
branches153613802branches
branchier1637132branchier
branching17289262branching
branchy17357912branch_y
bronchi14176312bronchi_
bronchial16175332bronchial
abrachias1645633abra_chias
bacchic1545813b_acchic
bacchii1644533b_acchii
banksia1335943b_anksia
banshie12129543b_anshie
blanch133410853blanch__
blanched16308603blanched
blancher15338633blancher
blanches153311603blanches
blanching17297093blanching
brach126123303bra_ch__
braches144621223bra_ches
brachet144020313bra_chet
brachials16206943bra_chials
brachiate1646873bra_chiate
brachium1766113bra_chium
brachs134415753bra_ch_s
brahma1336193bra__hma
brainchild1851973brainchild
branchiest1746713branchiest
branchlet1647183branchlet
branchline1744123branchline
brantail1046893brantail
breccia1344453br_eccia
bronchium1843373bronchium
broncho14206463bronch_o
bronchos15206173bronchos
bronchus15204743bronchus
brunch13329353brunch__
brunched16317853brunched
bruncher15347783bruncher
brunches153710453brunches
brunching17316483brunching
cancha134411613_canch_a
cranch133613533cranch__
cranched163210413cranched
cranches153114543cranches
cranching17278733cranching
crania82418433cran__ia
drachma1544303dra_chma
franchise1746003franchise
macchia1645893_macchia
rachial122012173_ra_chial
rachis114017653_ra_chis
ranch105019793_ranch__
ranched133113603_ranched
rancher123013633_rancher
rancheria1444663_rancheria
ranches123620113_ranches
ranching141712043_ranching
ranchman1546043_ranchman
rancho114310853_ranch_o
ranchos123911393_ranchos
rancid9513863_ranc_id
raphia113511263_ra_phia
trachea12311673tra_chea
tranche123312223tranch_e
tranches132915513tranches
tranship13410183tranship
urania62516123uran__ia

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162757.11020557.2
3Display Results75750.0302500.0
 (SQL Overall)178691757.29624491.6
 
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.