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

129 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
beaneries1131090(None) 
deaneries10310831deaneries
bakeries14312192b_akeries
beanies93821092bean__ies
braveries1439102braveries
eateries8324312_eateries
ferneries1239042ferneries
flaneries1249562flaneries
henneries1248642henneries
sealeries9313132sealeries
veneries112815032ve_neries
aeries64737783__a_eries
anergies9310453__anergies
aperies9423203__aperies
bandies104124863b_an_dies
banshies131110663b_anshies
banties94324763b_an_ties
batteries11615113batteries
bawdries14136843b_awdries
beaders104120183beader__s
beakers134216873beaker__s
beanery1237563beaner__y
beanie83618593bean__ie_
beanpoles1344313beanpoles
bearberries1553463bearberries
bearers94619593bearer__s
beasties102514653bea_sties
beaters94925043beater__s
beatifies1459283beatifies
beauties10229523bea_uties
beavered1437503beaver_ed
beavering1538703beavering
beavers124417323beaver__s
bebeerines1454023bebeerines
beedies10314203be__edies
beerier93613023be__erier
beeriest104013403be__eriest
beggaries1356233beggaries
belfries1336983be_lfries
benefices1645063be_nefices
benefits1345713be_nefits
bennies93917313be_n_nies
berberines1445633berberines
berberins1346713berberins
berberis1246603berberi_s
berberises1444903berberises
bergeres1189113berger_es
berries94423553be__rries
bewearies1447013bewearies
beworries1444843beworries
bibberies1297133bibberies
binaries10314183b_inaries
binderies12311683binderies
bobberies12107893bobberies
boiseries11411043boiseries
booteries11312773booteries
boweries13312293b_oweries
brandies11714563bran_dies
brasseries1246873brasseries
breweries1447583breweries
briberies1348333briberies
buggeries1347083buggeries
butleries11710073butleries
butteries11711763butteries
canaries10318943_canaries
canneries11313083canneries
celeries10316313ce_leries
chanceries1747653chanceries
chantries14310293chantries
creameries1446673creameries
dearies83526273dea__ries
draperies1249193draperies
emeries91620023_e_meries
emperies12314563_emperies
enemies9313693_e_nemies
energies9310783_e_nergies
entries71523163_e_ntries
faeries104118993_fa_eries
fakeries1559833_fakeries
fineries112416743_fineries
flanerie1146913flanerie_
gantries91413783_gantries
generics11118793ge_nerics
gentries91315263ge_ntries
granaries10159883granaries
graperies1239613graperies
greeneries1167073greeneries
gunneries1047043gunneries
helleries122611683helleries
henries102718283he_n_ries
imageries1246783imageries
japeries17311463_japeries
joineries1648103joineries
knaveries1645013knaveries
leaners73718173leaner__s
lecheries1449073lecheries
meaners94415243meaner__s
meanies93620743mean__ies
menageries1345853menageries
merceries13410043merceries
naperies10313903_naperies
nunneries947113nunneries
orangeries11116943orangeries
panfries13149203_panfries
pantries101817393_pantries
pedantries1345683pedantries
pedleries1298783pedleries
peeries93623023pe__eries
penuries10311663pe_nuries
pineries102419083_pineries
reentries9311763reentries
refineries1347063refineries
reveries112518513re_veries
sceneries1149393sceneries
sentries81318053se_ntries
slaveries1249683slaveries
swanneries1344363swanneries
tanneries9310423tanneries
teaberries1245123teaberries
tenantries1045673tenantries
ternaries9311643ternaries
traceries11312863traceries
turneries948493turneries
veeries102916893ve__eries
vineries112716043_vineries
weaners104613833weaner__s
wearies103020223wea__ries
wernerites1344943wernerites
wineries112316533_wineries

Search took 7 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 Limit1486411296.34623422.8
3Display Results1291290.0462804.3
 (SQL Overall)1786911296.81226231.8
 
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.