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

158 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
enmities1061135(None) 
entities8617411entities
amities9317382_amities
comities12317792comities
densities10310792densities
dimities11314002dimities
empties11712242e_mpties
endites83717062endit_es
enormities1246902enormities
entitles8710662entitles
equities17310772equities
lenities8315942len_ities
tensities9311332tensities
tenuities949762tenuities
unities72520152un_ities
unmitres1036862unmitres
acuities10312453acuities
amenities11310433amen_ities
analities9715873analities
anilities9516003anilities
annuities947463annuities
anxieties1646263anxieties
canities101519263canities
cavities131412613cavities
cecities12312043cecities
cities84524853__cities
deities82621923_deities
densifies1347993densifies
dominies113513193dominies
edacities1247773edacities
edifies113012283e_difies
effigies1543513effigies
eighties12710803eighties
elites66027123e_lit_es
emeries91620023e_meries
emetics11610723e_metics
emetines10611053e_metines
emetins9812643e_metins
emigres1037673e_migres
emits75421473e_mit__s
emitted103010853e_mitted
emitter93211083e_mitter
emitters10349643e_mitters
emotes84620283e_mot_es
emptied1297393e_mptied
emptier1187603e_mptier
emptiers1275193e_mptiers
emptiest1278103e_mptiest
emptins1179403e_mptins
enamines101112133enami_nes
enates64026433en_at_es
enclitics1345163enclitics
endite73817593endit_e_
endited93512913endit_ed
enditing10311073enditing
endives113710693endi_ves
enemies9313693en_emies
energies9310783energies
engines81114463engi_nes
enisles72312603en_isles
enlistees954583enlistees
enmeshes1345343enmeshes
enmity1137483enmit__y
enquiries1854383enquiries
enriches1337263enriches
ensiles72714833ensi_les
enskies1138573en_skies
entices91616333enti_ces
entires71517783enti_res
entireties1047273entireties
entitle7610293entitle_
entitled967503entitled
entries71523163en_tries
envies9314053en__vies
equites162212493equit_es
eremites10312603eremit_es
ermines9416673ermi_nes
evites94916473e_vit_es
excites16310633excit_es
expiries1747753expiries
families1339443families
ferities111416713ferities
fixities1838213fixities
fomites123613203fomit_es
furmities1447543furmities
genitives1346663gen_itives
hermitries1546763hermitries
homilies132710113homilies
hominies133012953hominies
identities1146953identities
inanities9312443inanities
incites93218483incit_es
indites83618983indit_es
inmates92715783inmat_es
intitles8710003intitles
invitees11377903invitees
invites103915813invit_es
laities7320343_laities
laxities1539093laxities
lenites7818443len_it_es
lenitives1247503len_itives
levities11310713levities
limites92915453limit_es
mites75141803__mit_es
mitier83620673__mitier
mitiest93520053__mitiest
mitis75425993__miti_s
mitises9315543__mitises
mitres83922073__mitres
nasties73520493_nasties
neckties1445903neckties
nifties102612503_nifties
nimieties1145223nimieties
nites55736343_n_it_es
nitres65519333_n_itres
nixies135313873_n_ixies
nudities939683nudities
oddities1046603oddities
parities10522973parities
penalities121313473penalities
penalties11139513penalties
penlites10312273penlit_es
pities83828083__pities
polities102722343polities
purities10316283purities
ramifies13310503ramifies
ramilies10311833ramilies
rarities8316333rarities
realities9316313realities
samites93118713samit_es
sanities81219773sanities
senilities10312993senilities
sensitise947293sensitise
sensitises1047643sensitises
sensitives1346133sensitives
sensitizes1946963sensitizes
smites83921923_smit_es
smithies1337913_smithies
somites94219123somit_es
tenacities1248583tenacities
termites10313693termit_es
unifies102714713un_ifies
unites65024853un_it_es
unitizes1739133un_itizes
unmiter9310393unmit_er
unmiters1037073unmiters
unmitre936993unmitre_
unmitred1136843unmitred
unmixes16197753unmi_xes
unpitied1138793unpitied
untidies939813untidies
unties64326923un__ties
vanities111414493vanities
venalities131510723venalities
venosities1347473venosities
verities111418043verities
vomitives1744613vomitives
whities133113253_whities

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.453394461.4
2DLD Change Limit1461621586.83021400.0
3Display Results1581580.0602633.3
 (SQL Overall)1786911587.34324334.9
 
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.