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

194 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
amberies12251468(None) 
ambaries123312381ambaries
ambries111614551amb_ries
aeries64737782a__eries
ambaris113112162ambari_s
amberina1247392amberina
amberinas1344612amberinas
amberoids1445332amberoids
ambers104519582amber__s
amerces1149852am_erces
amperes11313982amper_es
aperies9423202a_peries
arteries8321482arteries
auberges1146672auberges
dauberies1248032dauberies
emeries91620022em_eries
emperies12314562emperies
abbacies1445483abbacies
abbesses1235333abbesses
abeles84719393a_be_les
abelias93213563a_belias
abhenries1444503abhenries
abris75722603a_b_ri_s
adheres11310163adher_es
aerie54634603a__erie_
aeried74221863a__eried
aerier64823153a__erier
aeriest73924053a__eriest
albedoes1184533albedoes
albertites1244873albertites
algerines1069083algerines
allergies10137783allergies
almonries1156923almonries
ambages1269623amb_ages
ambari103012173ambari__
ambeer104511603ambe__er
ambeers11428923ambe_ers
amber94523213amber___
ambergris1452233ambergris
ambergrises1661683ambergrises
amberoid1346433amberoid
ambery133811133amber__y
ambiences1545253ambiences
ambits103713413amb__its
amblers115213563ambler__s
ambles105121863amb__les
ambones11312683amb_ones
ambroids1346503ambroids
ambsaces1455213ambsaces
ambushes1535803ambushes
ameerates1149063ameerates
ameers84015573ameer__s
amerce10310513am_erce_
amerced1256523am_erced
amercer1146373am_ercer
amercers1256133am_ercers
amies76837693am___ies
amities9317383am_ities
amnesias1047833amnesias
amnesics1255283amnesics
amnesties1166873amnesties
amperages1447683amperages
ampere10514413amper_e_
anergies9310453a_nergies
angaries9314393angaries
ankerites1348523ankerites
anserines9411293anserines
apiaries10312723apiaries
arbores94016033arbor_es
arborizes2088823arborizes
archeries14411223archeries
armories10313653armories
armouries1146243armouries
asperges11318093asperges
asperses104111673asperses
asterias8317013asterias
auberge1045633auberge_
aubergines1354273aubergines
auguries947933auguries
aviaries1139783aviaries
bakeries14312193bakeries
barberries1446233barberries
batteries11615113batteries
bayberries1744093bayberries
belies84631053__belies
berimes115216643__berimes
bermes106023003__bermes
berries94423553__berries
bevies114017303__bevies
bibberies1297133bibberies
bobberies12107893bobberies
boweries13312293boweries
briberies1348333briberies
bries74942153__b_ries
buries84633273__buries
cambered15129003camber_ed
cambering16109873cambering
cambers134017443camber__s
cambrics1645253camb_rics
canneries11313083canneries
catteries11815523catteries
causeries11510643causeries
cauteries11615393cauteries
celeries10316313celeries
coteries10422703coteries
daubries1136743daub_ries
doweries12411933doweries
duperies11312813duperies
eateries8324313eateries
embers104116183ember__s
embodies1337003embodies
embolies1239153embolies
embrues1136473emb_rues
emerges101310883em_erges
faeries104118993_faeries
fakeries1559833fakeries
fiberizes2346173fiberizes
fineries112416743fineries
galleries10311703galleries
gauderies1147743gauderies
hagberries1674243hagberries
imageries1246783imageries
imbeciles1543083imbeciles
imbodies1345483imbodies
imbrues1135503imb_rues
immerges1345393immerges
immerses1235953immerses
imperils1247713imperils
jaggeries18136973jaggeries
jamborees2043273jamborees
japeries17311463japeries
jobberies20115423jobberies
lamaseries1244893lamaseries
lambencies1643803lambencies
lambers113817113lamber__s
lamberts12348793lamber_ts
lambies113015113lamb__ies
lamperses1345123lamperses
liberties1149203liberties
liveries11314373liveries
maderizes2148953maderizes
marries93825283_marries
masteries111018493masteries
materiel10311253materiel
materiels1147833materiels
merces105720743_m_erces
mercies113817563_m_ercies
merdes94518603_m_erdes
meres75143573_m_er_es
merges94122493_m_erges
merises93421423_m_erises
merits8320873_m_erits
merles85322763_m_erles
miseries10320403miseries
moperies12313873moperies
mummeries1247243mummeries
murries94118673_murries
naboberies1443263naboberies
naperies10313903naperies
niteries8318383niteries
ombers104214403omber__s
ombres103911143omb_r_es
orreries8310123orreries
peeries93623023_peeries
pineries102419083pineries
plumberies1645123plumberies
poperies12316793poperies
puberties1346603puberties
queries16315873_queries
reburies10311143reburies
reveries112518513reveries
robberies13107393robberies
roperies10315763roperies
roseries8317313roseries
ruderies9311333ruderies
series64540973__series
soberizes2098963soberizes
suberins10315093suberins
suberise10813933suberise
suberises11813453suberises
suberizes20811833suberizes
subseries11312933subseries
tanneries9310423tanneries
umbered121510113umber_ed
umbering1399433umbering
umbers104215213umber__s
veeries102916893_veeries
veneries112815033veneries
vineries112716043vineries
voleries11313233voleries
waggeries14127463waggeries
wasteries121115343wasteries
waxberries2243133waxberries
wineries112316533wineries

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.423422437.4
2DLD Change Limit1461621947.43619656.0
3Display Results1941940.0932086.0
 (SQL Overall)1786911947.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.