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

224 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
bakeries1431219(None) 
fakeries1559831fakeries
aeries64737782_a_eries
aperies9423202_aperies
bakelites1545992bakelites
bakers125323452baker__s
basketries1645042basketries
batteries11615112batteries
bawdries14136842bawdries
beaneries11310902beaneries
boweries13312292boweries
braveries1439102braveries
eateries8324312eateries
faeries104118992fa_eries
japeries17311462japeries
naperies10313902naperies
abhenries1444503abhenries
aerie54634603_a_erie_
aeried74221863_a_eried
aerier64823153_a_erier
aeriest73924053_a_eriest
akees96119243_ake__es
akenes104817343_ake_nes
amberies122514683amberies
ambries111614553_ambries
amerces1149853_amerces
anergies9310453_anergies
ankerites1348523ankerites
arteries8321483arteries
babesias1246113babesias
babies106123653ba__bies
backers153821883backer__s
backfires2046173backfires
bacterias1349283bacterias
bacterins13410643bacterins
bacterizes2347973bacterizes
baddies114017873ba_ddies
baffies153612943ba_ffies
baggies113814853ba_ggies
bailies94120203ba_ilies
bakelite1447253bakelite
baker115629543baker___
bakery155911003baker__y
bakes117035373bak___es
bakewares1845043bakewares
baldies105317703ba_ldies
baldrics13164893baldrics
balefires1444803balefires
balers85626933baler__s
balkers134915723balker__s
ballies93725743ba_llies
bandies104124863ba_ndies
bankers133919093banker__s
banshies131110663banshies
banties94324763ba_nties
barberries1446233barberries
barbes104526233ba__rbes
barbies114519593ba_rbies
bardes95026933ba__rdes
bareges105212033bare_ges
bares75457133ba__r_es
barflies1338303barflies
barges94528253ba__rges
barites94322333ba__rites
barkers134318513barker__s
baronies10315023baronies
barres84427543ba__rres
barretries1246243barretries
barrier94017733ba_rrier
barriers104311883ba_rriers
barrios9310773ba_rrios
baryes116218503ba__ryes
baselines1138603baselines
basifies13310493basifies
batterie10711533batterie_
bawdies134613393ba_wdies
bawdrics16153273bawdrics
bawties124214313ba_wties
bayberries1744093bayberries
beakers134216873beaker__s
beedies10314203b_eedies
beerier93613023b_eerier
beeriest104013403b_eeriest
belfries1336983belfries
belies84631053b__elies
berimes115216643b__erimes
bermes106023003b__ermes
berries94423553b_erries
bevies114017303b__evies
bewearies1447013bewearies
bibberies1297133bibberies
bikers124517553biker__s
bikies124515163bik__ies
binaries10314183binaries
binderies12311683binderies
bobberies12107893bobberies
boiseries11411043boiseries
booteries11312773booteries
brakeages1643973brakeages
brasseries1246873brasseries
breweries1447583breweries
briberies1348333briberies
bries74942153b___ries
buggeries1347083buggeries
buries84633273b__uries
butleries11710073butleries
butteries11711763butteries
calories102919563calories
canaries10318943canaries
canneries11313083canneries
caries85147623ca__ries
carries94328013ca_rries
casefies1339213casefies
casernes103810753casernes
catteries11815523catteries
causeries11510643causeries
cauteries11615393cauteries
celeries10316313celeries
cookeries151210633cookeries
coteries10422703coteries
dairies84217733da_iries
dakerhen1642423dakerhen
dakerhens1742303dakerhens
dataries9314033dataries
dauberies1248033dauberies
daubries1136743daubries
deaneries10310833deaneries
doweries12411933doweries
draperies1249193draperies
duperies11312813duperies
emeries91620023_emeries
emperies12314563emperies
faerie93514683fa_erie_
fairies103516043fa_iries
fakers134219533faker__s
fineries112416743fineries
flackeries1955433flackeries
flaneries1249563flaneries
gaieties9310183gaieties
galeres83514343galer_es
galleries10311713galleries
gantries91413793gantries
gauderies1147743gauderies
gayeties1236883gayeties
graperies1239613graperies
haeres94017033ha_er_es
harries103525493ha_rries
imageries1246783imageries
jaggeries18136973jaggeries
kauries113613193ka_uries
kermes124616133__kermes
kernes104717533__kernes
kerries113317913__kerries
knackeries1544103knackeries
knaveries1645013knaveries
kyries133411373__kyries
lakers105225153laker__s
lakesides1444093lakesides
laterites9715063laterites
laterizes18513023laterizes
liveries11314373liveries
maderizes2148953maderizes
makers123921733maker__s
marries93825283ma_rries
masteries111018493masteries
materiel10311253materiel
materiels1147833materiels
miseries10320403miseries
mockeries17128263mockeries
monkeries15129913monkeries
moperies12313873moperies
niteries8318383niteries
orreries8310123orreries
panfries13149203panfries
pantries101817393pantries
paries84742513pa__ries
parries93925843pa_rries
pastries101517423pastries
peeries93623023_peeries
pineries102419083pineries
poperies12316793poperies
quackeries2544313quackeries
queries16315873_queries
rakees104516973rake__es
rakers104123573raker__s
rarefies1138993rarefies
rareripes1165353rareripes
reveries112518513reveries
rockeries15128973rockeries
rookeries13138173rookeries
roperies10315763roperies
roseries8317313roseries
ruderies9311333ruderies
safeties1139163safeties
sakers104125433saker__s
salaries8319593salaries
sauries72821623sa_uries
savories11311273savories
sealeries9313133sealeries
series64540973__series
skerries12168673_skerries
slaveries1249693slaveries
takers103923743taker__s
tanneries9310423tanneries
tarries73324263ta_rries
tawdries12136083tawdries
traceries11312863traceries
uakaris1146633uakari_s
vagaries12310293vagaries
valkyries1952633valkyries
varies94330873va__ries
veeries102916893_veeries
veneries112815033veneries
vineries112716043vineries
voleries11313233voleries
waggeries14127463waggeries
wakerife1843673wakerife
wakers134822493waker__s
walkyries1942673walkyries
wasteries121115343wasteries
wastries111212883wastries
waterier11312083waterier
wateriest12312233wateriest
wineries112316533wineries

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622246.37622923.8
3Display Results2242240.0932408.6
 (SQL Overall)1786912246.88925938.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.