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

382 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
deified12311241(None) 
defied115016381de_fied
deifier113013121deifier
deifies113317451deifies
edified12339711edified
reified112913781reified
aerified121310132aerified
daisied93410012daisied
decried112612852decried
defier105118652de_fier
defies104624052de_fies
defiled124013102defiled
defined123813822defined
deiced104214482dei_ced
deicide1149402deicide
deific1237312deifi_c
deifiers12348992deifiers
deigned1037502deigned
deities82621922deities
denied84318632de_nied
densified1446712densified
drifted12367952drifted
edifier11309262edifier
edifies113012282edifies
reifier103414522reifier
reifies104218282reifies
unified112413572unified
verified151510392verified
acetified1545893acetified
aeried74221863ae_ried
aerifies111313393aerifies
alibied1038143alibied
basified1437823basified
beatified1577863beatified
beefed123510873beef_ed
beefier12329093beefier
belfried1444203belfried
belied95022163be_lied
bellied104314073bellied
berried103714043berried
biffed15449883_biffed
bifid11910703_bifi_d
ceiled94114953cei_led
certified1548413certified
chivied16368383chivied
citied94014143_citied
citified1438253citified
codified1537403codified
coifed124113063coif_ed
coiffed1635413coiffed
daffed14429493d_affed
daffier1457833daffier
dailies84219263dailies
dairies84217733dairies
daisies84217093daisies
dallied93713613dallied
damnified1644883damnified
dandified1555553dandified
deafen10389673deaf_en
deafened1335853deafened
deafer104114813deaf_er
deafish1438533deafish
deaired9411533deaired
deaned84620453de_aned
dearie73319813dearie_
dearies83526273dearies
deashed123411303deashed
deaved114916553de_aved
debased113310583debased
debated113916083debated
debited113311623debited
deboned113411633deboned
debride1138593debride
debrided1336583debrided
debrief1337623debrief
debuted11379333debuted
decayed14309333decayed
deceived1535893deceived
decide104116873de_cide
decided124312423decided
decked145217623de_cked
declined123910883declined
decoded123212383decoded
decoyed14358333decoyed
decreed112710253decreed
decrier102713553decrier
decries103319803decries
deduced1266683deduced
deed65340903de___ed
deeded94615543de_eded
deedier93011593deedier
deemed104713063de_emed
defaced142910973defaced
defamed14309833defamed
defend113910493de_fend
defer94619753de_f_er
deffer134411303de_ffer
defi86321493de_fi__
defiers113913993de_fiers
defile105216663de_file
defiler113911883defiler
defiles114016843defiles
define104718143de_fine
definer114413773definer
defines114118683defines
defis96717503de_fi_s
deflea1037443de_flea
defter104215923de_fter
defuel10348933de_fuel
defund11447983de_fund
defused125211093defused
defuzed21447043defuzed
degreed10258883degreed
dehisced1583683dehisced
deice84320033dei_ce_
deicer94114413dei_cer
deices94119373dei_ces
deicides1249303deicides
deicing11312193deicing
deifical1445543deifical
deiform1336693deiform
deify124112763deif__y
deifying1637633deifying
deionized2057153deionized
deixis1437243deixi_s
deixises1635693deixises
deked115718533de__ked
delated93722873delated
delayed123310763delayed
deled75326543de__led
deleted93314913deleted
delimed11310723delimed
delimited1346593delimited
delisted10310563delisted
dellies83622213dellies
deluded10158763deluded
deluged10167413deluged
delved114112753de_lved
demies94825803de_mies
demised113613683demised
demitted12288773demitted
demoded123611123demoded
demoed103713443de_moed
demoted114313543demoted
denazified2443063denazified
denier74420693de_nier
denies74729643de_nies
denimed1159233denimed
denned84215633de_nned
denoted93512763denoted
densifies1347993densifies
dented84120513de_nted
dentiled1039743dentiled
denuded10167663denuded
depicted1437743depicted
deponed113712873deponed
deposed113412023deposed
deprived1546463deprived
depside1138403depside
deputed114610173deputed
derailed102410403derailed
derated93623503derated
derbies103016053derbies
deride84420033de_ride
derided102914253derided
derived123912763derived
dernier83011943dernier
derries83124623derries
descried1248073descried
desexed1636183desexed
designed1136943designed
desired9311983desired
desisted1039783desisted
desmid1048363desmi_d
despised1236923despised
despited1248323despited
destined103312453destined
detailed10319873detailed
detained103111643detained
deticked1635693deticked
detoxed1636103detoxed
detoxified2243083detoxified
deuced104112123de_uced
deveined1336673deveined
develed123611933develed
deviated13311043deviated
deviled124112183deviled
devilled1336743devilled
devised123712563devised
devoiced15276063devoiced
devoid1189363devoi_d
devoted124111093devoted
dewaxed19316053dewaxed
dewed105020303de__wed
dewier104013463de_wier
dexie134716893de_xie_
dexies145018343de_xies
dezinced2183903dezinced
dialed84716453d_ialed
dibbed124713473d_ibbed
diced95824683d_i_ced
dicier94416233d_icier
dicked144920863d_icked
didie74120563d_idie_
didies84621833d_idies
died66137853d___ied
dieted83115493d_ieted
differ133910843d_iffer
digged104314653d_igged
dignified1545573dignified
diked115024683d_i_ked
dilled84122223d_illed
dimmed124110323d_immed
dined76431993d_i_ned
dinged95221783d_inged
dinked124818353d_inked
dinned84317613d_inned
dinted84419843d_inted
dipped123517493d_ipped
dirked124912273d_irked
dirled84514903d_irled
dirtied93210853dirtied
disced104914653d_isced
dished114318713d_ished
disked125015763d_isked
dissed85220183d_issed
dived106321373d_i_ved
divide113410893d_ivide
divided13378593d_ivided
divined12329693d_ivined
divvied1544813divvied
dizzied17236133dizzied
doffed14428503d_offed
doiled84817293doi_led
doilies84017363doilies
doited85016633doi_ted
dollied93811143dollied
drafted12439033drafted
dribbed13326753dribbed
dried75321383d__ried
drifter11348703drifter
driftier1275123driftier
drilled94711673drilled
dripped13408083dripped
dulcified1644463dulcified
dummied13346723dummied
dwined114610213dwi_ned
eddied9248323_eddied
edifice1344933edifice
edifices1454863edifices
edifiers12336673edifiers
edited83913673edi_ted
envied1038833_envied
espied9359773_espied
feigned1245353feigned
feinted11379623feinted
feirie939553feirie_
feoffed1332813feoffed
ferried113411523ferried
fifed125115973_fif_ed
gasified1336533gasified
gifted114510703_gifted
grifted12379583grifted
hefted134911423he_fted
heifer1238203heif_er
heiled104415613hei_led
heinie92512663heinie_
heinies102514543heinies
heired103813043hei_red
heisted113210653heisted
herried113514453herried
humified1745653humified
identified1545053identified
ignified1386213ignified
ivied94710523__ivied
jellied15419223jellied
jellified2044813jellified
jemmied19294483jemmied
jettied15366973jettied
kerfed14358233kerf_ed
knifed14528123knif_ed
leafed105713873leaf_ed
leafier10329833leafier
levied104111433le_vied
lifted104413523_lifted
lilied73913213_lilied
meinie82614523meinie_
meinies92516073meinies
metrified1547853metrified
miffed15398713_miffed
minified1439653minified
modified1537273modified
nazified2144993nazified
neighed12135893neighed
nidified1346763nidified
notified1238363notified
ossified1276433ossified
pacified1638363pacified
peined94918843pei_ned
peised94817683pei_sed
petrified1548333petrified
pitied94017253_pitied
purified1438743purified
ramified1438043ramified
rarified1239053rarified
ratified12310503ratified
readied93316623readied
rectified1539243rectified
redefied1368223redefied
redried93714893redried
reedified1446503reedified
reefed103816583reef_ed
reefier102912553reefier
refed93921923re_f_ed
refeed104717623re_feed
reffed134712513re_ffed
refiled114318653refiled
refind104717073re_find
refined114720003refined
refired115116993refired
refixed183611153refixed
refried113513873refried
reifiers11309843reifiers
reigned949213reigned
reined74425523rei_ned
reinked1239793reinked
reived104518133rei_ved
relied74926233re_lied
replied103914453replied
resifted12310153resifted
retied75924983re_tied
retried84419153retried
reunified1346593reunified
riffed133811563_riffed
rifled104115003_rifled
rifted104115313_rifted
salified12310363salified
seined74023063sei_ned
seised74218123sei_sed
seized164313653sei_zed
selfed10310913self_ed
serifed11811463serif_ed
seriffed1594973seriffed
serried82513963serried
shifted14359983shifted
sifted104313673_sifted
sniffed14318183sniffed
specified1746253specified
spiffed16257103spiffed
spiffied17234823spiffied
stiffed14359583stiffed
stifled113511093stifled
stimied10310623stimied
teiid6312533tei_i_d
tepefied1444573tepefied
terrified13147573terrified
testified1397843testified
tidied83613273_tidied
tiffed13368393_tiffed
trifid1039063trifi_d
trifled113711963trifled
typified1743923typified
uglified1345293uglified
unifier102211863unifier
unifies102714713unifies
veiled103714543vei_led
veined104413913vei_ned
veinier10269583veinier
verbified18146013verbified
verifier14159203verifier
verifies141313483verifies
versified16147593versified
vilified1547243vilified
vinified1537543vinified
vivified1845893vivified
waifed134011033waif_ed
wearied112911803wearied
webfed1535033webf_ed
weighed15135933weighed
weirded1234513weirded
whiffed2064473whiffed
wifed125117743_wif_ed

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273826.20321606.8
3Display Results3823820.1402728.6
 (SQL Overall)1786913826.74926476.7
 
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.