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

121 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
edacity133637(None) 
audacity1444822audacity
dacite91115882_dacite
dacoity1366182_dacoity
feracity1646732feracity
megacity1645712megacity
mendacity1744152mendacity
opacity1436312opacity
predacity1745602predacity
tenacity1347112tenacity
veracity1647552veracity
acidy117214893__acidy
acuity1139373__acuity
alacrity1355483alacrity
amity10416093__amity
anality10313633anality
caducity1643883caducity
capacity1746023capacity
cavity14310013_cavity
cecity1398153_cecity
charity15311023charity
city95122623___city
clarity12310913clarity
dacites101114593_dacites
dacoit9415453_dacoit_
dacoits1079073_dacoits
dactyl1234983_dac_tyl
daily95922333_da_ily
dainty105311473_dainty
dairy97016303_da_iry
daisy95915313_da_isy
dakoity1543423_dakoity
davit93424593_davit_
davits104012363_davits
deity94316773_d_eity
density1137583density
dicty115116293_dic_ty
dimity12310473_dimity
duality1147963duality
easily9313023e_asily
edacious1146023edacious
edacities1247773edacities
edgily1136063ed_gily
edict84722283edic_t_
edicts94911703edic_ts
edify12308563ed__ify
edit54934863ed__it_
edits65819033ed__its
educate10310213educate
educing1137683educing
educt85017103educ_t_
educts9439893educ_ts
egalite8311563egalite
elicit8417203elicit_
elicits9311233elicits
emaciate1248753emaciate
enact73525363enac_t_
enacts84012973enac_ts
enmity1137483e_nmity
entity9312053e_ntity
epact94921533epac_t_
epacts105010393epac_ts
equality2046993equality
equity1838103e_quity
exact143516933exac_t_
exacta15337393exac_ta
exactly1953823exactly
exacts15359613exac_ts
excite15310883e_xcite
felicity1647913felicity
ferocity1645993ferocity
feudality1654393feudality
fugacity1743313fugacity
gravity1437183gravity
helicity1648503helicity
ideality1247153ideality
inanity1039503inanity
lacily11612763_lacily
laity85318903_la_ity
laxity1637273_laxity
legality1237623legality
mendicity1745073mendicity
minacity1547373minacity
modality14117653modality
mordacity1743513mordacity
nodality12127423nodality
oddity1135243od_dity
opacify1743653opacify
orality101111683orality
outcity1238453outcity
ovality1377593ovality
pacify1667473_pacify
parity114719873_parity
paucity1435823paucity
penality13310713penality
quality1938563quality
racily11715173_racily
rapacity1544983rapacity
rarity93615493_rarity
raucity1235853raucity
reality10313573reality
redact9419043redac_t_
redacts10510943redac_ts
regality1249313regality
repacify1843483repacify
sagacity1445243sagacity
salacity1347853salacity
sanity9316203_sanity
scarcity1545093scarcity
sedulity1245843sedulity
sequacity2343823sequacity
sodality12127323sodality
suavity1336313suavity
tacit76333673_tacit_
tacitly1236223_tacitly
vacuity1545763_vacuity
vanity12311933_vanity
velocity1644953velocity
venality1438683venality
vivacity1943993vivacity
voracity1645533voracity

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271217.25018486.5
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.68623248.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.