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 “aeries” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

181 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
aeries6473778(None) 
aerie54634601aerie_
aeried74221871aeried
aerier64823151aerier
aeriest73924051aeriest
aperies9423201aperies
faeries104118991faeries
series64540971series
abris75722602abri_s
acres76327762acr_es
aedes64625152ae_des
aediles83413902aediles
aegis6316782aegi_s
aegises8311372aegises
aerates74627492aerates
aerial64625712aerial
aerials74017552aerials
aerifies111313392aerifies
aerify122810112aerify
aerily93017012aerily
aerobes9311492aerobes
afrits9311902afrits
aggies83515512aggies
agrees74915322agrees
agrias74315392agrias
airier64619362airier
airiest74221012airiest
alkies104518092alkies
allies63827672allies
amberies122514682amberies
ambries111614552ambries
amerces1149852amerces
amies76837692a_mies
anergies9310452anergies
apres75426402apr_es
arenes64928392arenes
ares45871022a_r_es
aretes64425352aretes
arias55438022a_rias
ariel55228972a_riel
ariels65119372a_riels
arils58732202a_rils
arise56436432a_rise
arises65233802a_rises
arles56735742a_rles
armies85123692armies
arris56824682arri_s
arrises71617582arrises
arrives101311512arrives
arses55733872a_rses
arteries8321482arteries
aures55137092aur_es
auris55331532auri_s
bakeries14312192bakeries
belies84631052belies
berimes115216642berimes
bermes106023002bermes
berries94423552berries
bevies114017302bevies
bries74942152_bries
buries84633272buries
caries85147622caries
carries94328012carries
ceres75540012cer_es
cerias83321982cerias
cerise84822042cerise
cerises94722252cerises
cerites94823432cerites
certes84623082certes
cries75438402_cries
curies84934022curies
dairies84217732dairies
dearies83526272dearies
decries103319812decries
defies104624052defies
demies94825802demies
denies74729642denies
derbies103016052derbies
derides93420852derides
derives114017812derives
derries83124622derries
dexies145018342dexies
dories75232362dories
dries64733672_dries
easies64126632easies
eateries8324312eateries
eerie55228532eerie_
eerier64320022eerier
eeriest73620672eeriest
emeries91620022emeries
ernes55224812_ernes
erses55826802_erses
eyries93816812eyries
faerie93514682faerie_
fairies103516042fairies
fakeries1559832fakeries
feres86038182fer_es
ferias95020392ferias
ferlies103216692ferlies
ferries103521082ferries
fries85535602_fries
furies95126372furies
genies75324942genies
haeres94017032haer_es
harries103525492harries
henries102718282henries
heres86245902her_es
heroes94923822heroes
herpes115517322herpes
herries104025072herries
japeries17311462japeries
jerids142810942jerids
jerkies183411582jerkies
jerries143817512jerries
juries134120632juries
kauries113613192kauries
kermes124616132kermes
kernes104717532kernes
kerries113317912kerries
kyries133411372kyries
levies93919862levies
lories64933042lories
marries93825282marries
merces105720742merces
mercies113817562mercies
merdes94518602merdes
meres75143572mer_es
merges94122492merges
merises93421422merises
merits8320872merits
merles85322762merles
naperies10313902naperies
nereis6315342nereis
nerves94216192nerves
newies91014072newies
paries84742512paries
parries93925842parries
peeries93623022peeries
peres76246642per_es
perils84121852perils
peris75537072peri_s
perries93226602perries
perses85428062perses
pries74339532_pries
queries16315872queries
redries83721712redries
refries104419732refries
relies65036422relies
rerigs74014792rerigs
rerise64325632rerise
rerises73525882rerises
reties65436192reties
retries74129072retries
sauries72821622sauries
scries85226822scries
seres55448892ser_es
serges74225972serges
serifs94017052serifs
serines74229542serines
serins64029672serins
serries73925352serries
serves94423652serves
tarries73324262tarries
terces83921412terces
ternes65422902ternes
terries73425632terries
tories65435882tories
tries55742812_tries
varies94330872varies
veeries102916892veeries
vegies104314272vegies
verges104320182verges
verier94620962verier
veriest103719132veriest
verites103822262verites
vermes115019142vermes
verses94223762verses
verves124617882verves
wearies103020222wearies
wries85827742_wries
zeroes154314342zeroes

Search took 5 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 Filter178691825510.750238254.7
2DLD Change Limit825511813.46623817.4
3Display Results1811810.0463934.8
 (SQL Overall)1786911814.26241926.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.