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

102 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
breweries144758(None) 
bewearies1447012b_ewearies
boweries13312292b_oweries
braveries1439102braveries
brewers123811062brewer__s
brewskies18132272brewskies
briberies1348332briberies
reveries112518512_reveries
archeries14411223archeries
arteries8321483ar_teries
bakeries14312193b_akeries
batteries11615113batteries
bawdries14136843b_awdries
beaneries11310903beaneries
beedies10314203b_e_edies
beerier93613023b_e_erier
beeriest104013403b_e_eriest
belfries1336983b_elfries
berberines1445633berberines
berberins1346713berberins
berberis1246603berberi_s
berberises1444903berberises
bergeres1189113berger_es
berries94423553b_e_rries
bewares12313373b_ewar_es
bewearied1544203b_ewearied
beworries1444843b_eworries
bibberies1297133bibberies
binderies12311683binderies
bobberies12107893bobberies
boiseries11411053boiseries
booteries11312783booteries
brasseries1246873brasseries
breeches15258673bre_eches
breezes18318693bre_e_zes
breezier1934533bre_ezier
breeziest2035063bre_eziest
brevetcies1782203brevetcies
breviaries1564003breviaries
brevities1446423brevities
brewages1436383brew_ages
brewer114812553brewer___
brewery15376963brewer__y
brewis11469983brew__i_s
brewises1337213brew_ises
brewskis17111893brewski_s
brogueries1344813brogueries
broideries1346353broideries
brownies13189613brow_nies
buggeries1347083buggeries
butleries11710073butleries
butteries11711763butteries
celeries10316313_celeries
creameries1446673creameries
creepies1239613cre_epies
doweries12411933_doweries
draperies1249193draperies
drearies92313413dre_aries
emeries91620023__emeries
ferneries1239043ferneries
freebies1337873fre_ebies
freewrites1643573freewrites
graperies1239613graperies
greeneries1167073greeneries
greenies9312673gre_enies
groceries1249503groceries
jewelries1943033_jewelries
merceries13410043merceries
orreries8310123or_reries
peeries93623023_pe_eries
predries112714383pre_dries
preemies12512193pre_emies
preserves14109073preserves
preterites12411793preterites
preterits11410963preterits
prewires133811013prewir_es
pruderies1247873pruderies
reburies10311143_reburies
redefies12710163_redefies
redenies9615713_redenies
redries83721713_re_dries
referees111310413_referees
refries104419733_re_fries
remedies11310553_remedies
remerges111110203_remerges
reserves111011983_reserves
retries74129073_re_tries
revelries1246923_revelries
reveres103621343_rever_es
reverie103615163_reverie_
reverses112513513_reverses
reweaves1436603_reweaves
rewires104717113_rewir_es
rewrites11311063_rew_rites
rezeroes1737143_rezeroes
roperies10315763_roperies
roseries8317323_roseries
ruderies9311333_ruderies
sceneries1149393sceneries
traceries11312863traceries
veeries102916893_ve_eries
veneries112815033_veneries

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.423422437.4
2DLD Change Limit1486411027.48319863.8
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.95222471.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.