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

273 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
edifies11301228(None) 
deifies113317441deifies
edifices1454861edifices
edified12339711edified
edifier11309261edifier
edifiers12336671edifiers
aerifies111313392aerifies
codifies1439642codifies
defies104624052_defies
deified123112412deified
deifier113013122deifier
deifiers12348992deifiers
deities82621922deities
didies84621832_didies
eddies83313162ed_dies
edibles1047992edibles
edifice1344932edifice
ediles74016972edi_les
modifies1439162modifies
nidifies1238222nidifies
redefies12710162redefies
reedifies1347322reedifies
reifies104218282reifies
unifies102714712unifies
verifies141313482verifies
acetifies1447123acetifies
acidifies15126443acidifies
aediles83413893aedi_les
aerified121310133aerified
alibies9313323alibies
amities9317383amities
baffies153612943baffies
bailies94120203bailies
basifies13310483basifies
beatifies1459273beatifies
bedirties1275683bedirties
biddies113514493biddies
biffies152710853biffies
bikies124515163_bikies
brinies93317913brinies
cecities12312043cecities
certifies14310313certifies
chilies124218303chilies
chivies153412853chivies
cities84524853_cities
citifies13310673citifies
civies114116443_civies
codified1537403codified
codifier1447153codifier
codifiers1555343codifiers
coiffes1546803coiffes
dailies84219253dailies
dairies84217723dairies
daisies84217083daisies
dandifies1476883dandifies
davies105020513_davies
dearies83526273dearies
decries103319803decries
defied115016383_defied
defier105118653_defier
defiers113913993_defiers
defiles114016843defiles
defines114118683defines
defis96717503_defi_s
deices94119373dei_ces
deicides1249303deicides
deific1237313deifi_c
deixis1437243deixi_s
deixises1635693deixises
dellies83622213dellies
demies94825803_demies
denies74729643_denies
densifies1347983densifies
derbies103016053derbies
derries83124623derries
dexies145018343_dexies
diaries83321943_diaries
dices86434243_di_ces
dicier94416233_dicier
diciest103316523_diciest
dickies143416343_dickies
didie74120563_didie_
didoes85716963_didoes
dienes75719903_dienes
dies55653523_d__ies
dieses75218693_dieses
differ133910843_differ
differs14339973_differs
diffs126315483_dif_fs
difs86027323_dif__s
digits84114533_digits
dikes105831333_di_kes
dillies84122153_dillies
dimes85833043_di_mes
dines66449153_di_nes
dinges83825423_dinges
dingies93618243_dingies
dinkies123716033_dinkies
diodes83915783_diodes
dirges84915103_dirges
dirties83119373_dirties
dishes104622653_dishes
dismes95617673_dismes
disses75225953_disses
dites66339153_di_tes
ditties83116973_ditties
ditzes163212423_ditzes
dives95832403_di_ves
divides123211453_divides
divines113514723_divines
divvies1457663_divvies
dixits144210313_dixits
dizzies16279753_dizzies
dobies94422083_dobies
dogies85022253_dogies
doilies84017363doilies
dories75232363_dories
doxies143917853_doxies
dries64733673_d_ries
duties74921903_duties
easies64126633e_asies
ebonies9312883ebonies
edacities1247773edacities
eddied9248323ed_died
eddoes8199143ed_does
edges75718723ed__ges
edgier8469723ed_gier
edgiest92310353ed_giest
edible969353edible_
edicts94911703edi_cts
edify12308563edif__y
edifying1636083edifying
edile64819493edi_le_
edited83913673edi_ted
editing9313133editing
edition8310853edition
editions9310403editions
editors839423editors
editress944933editress
editrices1245323editrices
editrixes1743813editrixes
edits65819033ed__its
educes94011953ed_uces
effigies1543513effigies
egises7312493egi_ses
elegies81312903elegies
elfins94810943e_lfins
elicits9311233elicits
elides74420693eli_des
elites66027123eli_tes
elixirs1443543elixirs
emeries91620023emeries
emigres1037673emigres
empties11712243empties
endites83717063endi_tes
endives113710693endi_ves
enemies9313693enemies
enisles72312603enisles
enmities10611353enmities
enskies1138573enskies
entities8617413entities
entries71523163entries
envies9314053e_nvies
epoxies1637753epoxies
equities17310773equities
espies83716803e_spies
evinces1237803evinces
evites94916473evi_tes
exiles134816403exi_les
exines135715803exi_nes
expiries1747753expiries
eyries93816813e_yries
fairies103516043fairies
ferities111416713ferities
fifes114822393_fif_es
fifties132111083_fifties
gasifies1238683gasifies
giddies103713363giddies
griffes14367923griffes
heinies102514543heinies
idiocies1145223idiocies
ignifies1277553ignifies
ivies84215753__ivies
jellifies1946263jellifies
jiffies20327473jiffies
kiddies133412283kiddies
knifes136210213knif_es
laities7320343laities
lenities8315943lenities
levities11310713levities
lilies63021413_lilies
medflies1435553medflies
mediacies1447183mediacies
mediates112814063mediates
medicides1556583medicides
medicines1447903medicines
meinies92516073meinies
metrifies1439793metrifies
middies113116153middies
minifies13312883minifies
modified1537273modified
modifier1446693modifier
modifiers1584473modifiers
nazifies2036053nazifies
neddies92710703ned_dies
nidified1346763nidified
nifties102612503_nifties
nixies135313873_nixies
notifies11310413notifies
nudities939683nudities
oddities1046603oddities
orifices1346483orifices
ossifies1177553ossifies
pacifies15311213pacifies
pedicles1338663pedicles
petrifies14310353petrifies
pities83828083_pities
pixies154915513_pixies
privies122414263privies
purifies13311923purifies
ramifies13310493ramifies
rarifies11311923rarifies
ratifies11313503ratifies
recodifies16106313recodifies
rectifies14310803rectifies
redefied1368223redefied
redefines1347413redefines
redenies9615713redenies
redfins1139923red_fins
redivides1445683redivides
redries83721713red_ries
reedified1446503reedified
reified112913783reified
reifier103414523reifier
reifiers11309843reifiers
remodifies16116023remodifies
reunifies1247583reunifies
rifles94217703_rifles
roofies103014413roofies
salifies11314783salifies
specifies1647563specifies
spiffies16277973spiffies
stiffies14258363stiffies
stifles103013373stifles
stimies9316543stimies
taffies133012693taffies
teddies92711283ted_dies
tepefies1346893tepefies
terrifies12139703terrifies
testifies12139253testifies
tidies74721833_tidies
toffies133210213toffies
trifles103814823trifles
typifies1644963typifies
uglifies1246383uglifies
unified112413563unified
unifier102211863unifier
unifiers11237173unifiers
unities72520143unities
verbifies17157123verbifies
verified151510393verified
verifier14159203verifier
verifiers15166063verifiers
verities111418043verities
versifies15159323versifies
vilifies1439583vilifies
vinifies1439863vinifies
vivifies1747013vivifies
waffies163611443waffies
wedgies123910203wed_gies
whities133113253whities
widdies123514033widdies
wifes114522563_wif_es

Search took 9 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 Filter1786911340270.203880251.2
2DLD Change Limit1340272738.17316398.8
3Display Results2732730.0932935.5
 (SQL Overall)1786912738.46921099.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.