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

207 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
aerifies11131339(None) 
aerified121310131aerified
verifies141313481verifies
acetifies1447132acetifies
aeries64737782aer__ies
certifies14310322certifies
deifies113317452de_ifies
edifies113012282_edifies
ferities111416712ferities
metrifies1439802metrifies
petrifies14310362petrifies
purifies13311922purifies
rarifies11311932rarifies
reifies104218282re_ifies
terrifies12139722terrifies
verbifies17157132verbifies
verified151510392verified
verifier14159202verifier
verifiers15166062verifiers
verities111418042verities
versifies15159332versifies
abridges1245303abridges
accidies1338043accidies
acerbities1444973acerbities
acetified1545893acetified
acetifier1444863acetifier
acetifiers1543403acetifiers
acidifies15126453acidifies
acridines1247723acridines
acuities10312453acuities
aediles83413903aedi_les
aegises8311373aegi_ses
aerates74627493aer_ates
aerials74017553aeri_als
aerie54634603aer__ie_
aeried74221863aer__ied
aerier64823153aer__ier
aeriest73924053aer__iest
aeriform1346093aeriform
aerify122810113aerif__y
aerifying1636493aerifying
aerobes9311493aer_obes
aerobics1246833aerobics
aerofoils1243393aerofoils
aerolites9312583aerolites
agrafes1137523agraf_es
agraffes1553043agraffes
alibies9313323a_libies
alterities10411043alterities
amenities11310433amenities
amities9317383a_mities
amplifies16106703amplifies
anergies9310453aner_gies
aperies9423203aper__ies
aperitifs1444413aperitifs
argufies1243743argufies
arises65233803a_ri_ses
armies85123693a_r_mies
arrises71617583arri_ses
arrives101311513arri_ves
artifices1446473artifices
asperities1249763asperities
auricles10138333auricles
basifies13310493basifies
beatifies1459283beatifies
berimes115216643beri_mes
berries94423553ber_ries
brinies93317913_brinies
calcifies1638923calcifies
caprifigs1742703caprifigs
carnifies1439893carnifies
cecities12312043cecities
cerises94722253ceri_ses
cerites94823433ceri_tes
certified1548413certified
certifier1447353certifier
certifiers1545143certifiers
citifies13310683citifies
clarifies1448633clarifies
clerisies1147253clerisies
codifies1439643codifies
cornifies1439003cornifies
damnifies1545543damnifies
dandifies1476893dandifies
defies104624053de__fies
deified123112413de_ified
deifier113013123de_ifier
deifiers12348993de_ifiers
deities82621923de_ities
densifies1347993densifies
derbies103016053der_bies
derides93420853deri_des
derives114017813deri_ves
derries83124623der_ries
edifices1454863_edifices
edified12339713_edified
edifier11309263_edifier
edifiers12336673_edifiers
esterifies1347153esterifies
etherifies1645283etherifies
faeries104118993faer__ies
falsifies1545983falsifies
fancifies1767083fancifies
ferlies103216693fer_lies
ferries103521083fer_ries
fortifies1548693fortifies
gasifies1238693gasifies
gentrifies1446893gentrifies
glorifies1346363glorifies
griffes14367923_griffes
heinies102514543he_inies
heresies11312693heresies
herries104025073her_ries
horrifies15146393horrifies
ignifies1277563ignifies
jellifies1946263jellifies
jerkies183411583jer_kies
jerries143817513jer_ries
kerries113317913ker_ries
lenities8315943lenities
levities11310713levities
magnifies1547283magnifies
meinies92516073me_inies
mercies113817563mer_cies
merises93421423meri_ses
merisis93213173merisi_s
metrified1547853metrified
micrifies16118673micrifies
minifies13312903minifies
modifies1439163modifies
mortifies1439393mortifies
nazifies2036063nazifies
nidifies1238233nidifies
nigrifies1346363nigrifies
nitrifies12107923nitrifies
notifies11310423notifies
orifices1346483_orifices
ossifies1177563ossifies
pacifies15311223pacifies
parities10522973parities
perfidies1546603perfidies
perigees1189503perigees
periques1937653periques
perishes13313753perishes
periwigs1444193periwigs
perries93226603per_ries
petrified1548333petrified
petrifier1447123petrifier
petrifiers1544673petrifiers
privies122414263_privies
purified1438743purified
purifier1338573purifier
purifiers1435873purifiers
purities10316283purities
ramifies13310503ramifies
rarefies1138993rarefies
rarified1239053rarified
rarities8316333rarities
ratifies11313513ratifies
rectifies14310813rectifies
redefies12710163redefies
reedifies1347323reedifies
reified112913783re_ified
reifier103414523re_ifier
reifiers11309843re_ifiers
repurifies1546143repurifies
rerises73525883reri_ses
reunifies1247583reunifies
reverifies1645973reverifies
rifles94217703__rifles
sacrifices17134413sacrifices
salifies11314793salifies
salsifies1247253salsifies
scarifies1439603scarifies
scorifies1448023scorifies
seriates82620673seriates
sericins10312463sericins
series64540973ser__ies
serifed11811463serif_ed
seriffed1594973seriffed
serifs94017053serif__s
serines74229543seri_nes
serries73925353ser_ries
specifies1647573specifies
strifes104716583strif_es
tackifies1845783tackifies
tepefies1346893tepefies
terries73425633ter_ries
terrified13147573terrified
terrifier12126603terrifier
terrifiers13144573terrifiers
testifies12139263testifies
torrifies12137033torrifies
trifles103814823_trifles
typifies1644963typifies
uglifies1246383uglifies
unifies102714713_unifies
verbified18146013verbified
verites103822263veri_tes
versified16147593versified
versifier15156533versifier
versifiers16154143versifiers
vilifies1439593vilifies
vinifies1439873vinifies
vitrifies1547223vitrifies
vivifies1747023vivifies
weirdies12255783weirdies

Search took 10 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.706253103.4
2DLD Change Limit1461622078.70016800.2
3Display Results2072070.0962156.3
 (SQL Overall)1786912079.50218805.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.