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

70 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
bracioles134649(None) 
braciolas1345071braciolas
braciole1246971braciole_
braciola1245272braciol_a
bracteoles1443412bracteoles
brailles1039492bra_illes
bricoles122610302bric_oles
graciles112511612graci_les
bacillus1245153b_acillus
barcaroles1443803barcaroles
beanpoles1344313beanpoles
boracites1347953boraci_tes
borecoles1345973borec_oles
brabbles11349753bra_bbles
bracelet12310693brac_elet
bracelets1345963brac_elets
braces108427773brac___es
braches144621223brac__hes
brachials16206943brachial_s
brachiates1746353brachiates
bracings13369293braci_ngs
bracteole1343313bracteole_
bractless1335543brac_tless
bractlet1239283brac_tlet
bractlets1344753brac_tlets
brailed103914013bra_i_led
braille939713bra_ille_
brailled1147193bra_illed
brailler1036883bra_iller
braillers1135553bra_illers
brails84621293bra_i_l_s
brainless1136403bra_inless
braises93818873bra_i_ses
braizes183112453bra_i_zes
brambles14308973bra_mbles
brasils9410973brasi_l_s
brattles10199333bra_ttles
bravoes12418533bra_vo_es
braxies16711463braxi__es
brazils1867753brazi_l_s
brickles162810283bric_kles
bricole112810493bric_ole_
bridles104114473br__idles
broccolis1543803broccolis
brocolis1247303broc_olis
bronchioles1852863bronchioles
brucines1237763bruci_nes
caracoles13310083carac_oles
carioles10817073_carioles
carrioles1169473carrioles
crackles164111273crac_kles
crucibles1543743crucibles
darioles9710693_darioles
gracile102512603graci_le_
gracilis11247033graci_lis
graciosos1243253graciosos
gracious1138593gracio_us
grackles15309183grac_kles
oracles93212423orac__les
orioles7412993or__ioles
ovarioles1244613ovarioles
radicles11249703_radicles
rampoles1238893_rampoles
ratholes11312413_ratholes
raviolis1146103_raviolis
tracheoles1545623tracheoles
trachles13311753trac_hles
uracils939373uraci_l_s
vacuoles1345013_vacuoles
varioles11711123_varioles

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.436409841.7
2DLD Change Limit148641706.59322545.3
3Display Results70700.0332121.2
 (SQL Overall)178691707.06225303.2
 
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.