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

219 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
enmity113748(None) 
entity9312051entity
amity10416092_amity
comity13312712comity
density1137582density
dimity12310472dimity
emit65438422e_mit_
emits75421472e_mits
empty1247762e_mpty
endite73817592endite
enormity1344972enormity
equity1838102equity
lenity9612712len_ity
mity95528212__mity
tensity1039102tensity
tenuity1037452tenuity
unity84918492un_ity
acuity1139373acuity
admit8319493admit_
admits9411413admits
amenity1238333amen_ity
anality10313633anality
anility10312723anility
annuity1045543annuity
anxiety1744033anxiety
beamily1477393beamily
cavity14310013cavity
cecity1398153cecity
city95122623__city
deity94316773_deity
demit84832303demit_
demits94918073demits
densify1435293densify
easily9313023easily
edacity1336373edacity
edgily1136063edgily
edify12308563e_dify
edit54934863e_dit_
edits65819033e_dits
eerily92913563eerily
effigy1642213effigy
eighty133711603eighty
elite56230183e_lite
elmier839813elmier
elmy95616793elm__y
embay123410603e_mbay
emery104814333e_mery
emic86422753e_mi_c
emir65918703e_mi_r
emirs76116163e_mirs
emmet94221383emmet_
emmets10349153emmets
emmy116013243e_m_my
emote75421193e_mote
enact73525363enact_
enacts84012973enacts
enamine91214313enamine
enate54428143en_ate
enatic8317563enatic
encina8310443encina
ending83220253ending
endited93512913endited
endites83717063endites
endive103310473endive
enemata948013enemata
enemies9313693enemies
enemy1059993en_emy
energy10137513energy
engild8107613engild
engine71114863engine
engird8126973engird
engirt71112613engirt
enjoy1545963en_joy
enlist6417043enlist
enlists749393enlists
enmesh1134893enmesh
enmities10611353enmities
enquiry19254043enquiry
enrich1138943enrich
ensign737523ensign
ensile62616473ensile
ensky1235093en_sky
entia5318203enti_a
entice81316863entice
entire61617703entire
entirety1146063entirety
entitle7610293entitle
entry82414263en_try
envied1038833envied
envier939673envier
envies9314053envies
enviro936303enviro
envoy1156723en_voy
envy10411253en__vy
enwind10298083enwind
eolith93013903eolith
eremite9312833eremite
ermine8416923ermine
evite85317683e_vite
excite15310883excite
exit114428673e_xit_
exits125515913e_xits
expiry1834653expiry
family143311703family
ferity122813343ferity
fixity19427803fixity
fomite113314073fomite
fruity12429693fruity
furmity1535183furmity
gamily123712183gamily
gemmily1534603gemmily
gnatty10336483gnatty
henbit111412003henbit_
henbits12177003henbits
hermit11519443hermit_
hermitry1644453hermitry
hermits12312143hermits
homily144712333homily
hominy144511483hominy
identity1245373identity
inanity1039503inanity
incite83618733incite
indite73520323indite
inmate82917363inmate
invite93715033invite
jiminy1836273jiminy
knit85728143kn_it_
knits93914743kn_its
knotty13315223knotty
laity85318903_laity
laxity1637273laxity
lenite6719983len_ite
levity1277903levity
limit73126343limit_
limits82514143limits
milty104720073__milty
minty106323903__minty
miry96326753__miry
misty106120453__misty
mite66249413__mite
mitt66145493__mitt
nasty85717283_nasty
natty85719143_natty
netty85816763_netty
nifty115211633_nifty
nimiety1244633nimiety
nit37065943_n_it_
nite45943583_n_ite
nits45741643_n_its
nitty85418313_nitty
nixy145714513_n_ixy
noily86120993_noily
noisy86813363_noisy
nudity1037993nudity
nutty84816873_nutty
oddity1135243oddity
omit65337373_omit_
omits75018263_omits
parity114719873parity
penality13310713penality
penalty1267743penalty
penlite9313243penlite
permit10321683permit_
permits11314003permits
pity96031933__pity
polity113015863polity
purity114114913purity
ramify14268753ramify
rarity93615493rarity
reality10313573reality
reemit8717223reemit_
reemits9611303reemits
remit75737223remit_
remits85622943remits
samite83020603samite
sanity9316203sanity
senility1139683senility
seniti64317223sen_iti
sennit63117923sennit_
sennits73811283sennits
smit65138413_smit_
smite75224873_smite
smith107818053_smith
smithy14508273_smithy
snit46342473sn_it_
snits54124833sn_its
snooty94211513snooty
snotty9489203snotty
snouty9419953snouty
somite84519373somite
tenacity1347113tenacity
tenty86121603ten__ty
termite9313893termite
unfit84518563unfit_
unfitly1335573unfitly
unfits93910293unfits
unify113611113un_ify
unit45140073un_it_
unite54828383un_ite
units54923433un_its
unlit55025463unlit_
unmet74426393unmet_
unmiter9310393unmiter
unmitre936993unmitre
unmix14388973unmi_x
unmixt15378703unmixt
untidy1059153untidy
unwit84417523unwit_
unwits9389893unwits
uppity1335103uppity
vanity12311933vanity
venality1438683venality
venosity1446023venosity
verity123714853verity
vomit102622573vomit_
vomito11238033vomito
vomits112610923vomits
whity145513473_whity
zenith1839073zen_ith

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 Filter1786911127160.376475242.0
2DLD Change Limit1127162195.59320153.0
3Display Results2192190.0633476.2
 (SQL Overall)1786912196.03229623.8
 
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.