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

112 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
opacity143631(None) 
opacify1743651opacify
capacity1746022capacity
edacity1336372edacity
orality101111682orality
outcity1238452outcity
ovality1377592ovality
pacify1667472_pacify
parity114719872_parity
paucity1435822_paucity
rapacity1544982rapacity
voracity1645532voracity
acidy117214893__acidy
acuity1139373__acuity
alacrity1355493alacrity
amity10416093__amity
anality10313633anality
apatite9312963apatite
audacity1444823audacity
boracite1249193boracite
cavity14310013_cavity
cecity1398153_cecity
charity15311023charity
city95122623___city
clarity12310913clarity
conicity15411093conicity
dacite91115883_dacite
dacoity1366183_dacoity
duality1147973duality
epact94921533epac_t_
epacts105010393epac_ts
feracity1646733feracity
fugacity1743323fugacity
gravity1437183gravity
imparity1546783imparity
inanity1039503inanity
ionicity1348833ionicity
lacily11612763_lacily
laity85318903_la_ity
laxity1637273_laxity
locality13148433locality
loquacity2342483loquacity
megacity1645713megacity
minacity1547373minacity
modality14117653modality
molality13118363molality
molarity13118903molarity
morality131110333morality
mordacity1743513mordacity
nodality12127423nodality
nonparity1446753nonparity
nopalito1046063nopalito
obesity1275653obesity
oddity1135243o_ddity
opacities1347943opacities
opaline9412483opaline
ophite11410563op_hite
outpity1237493outpity
oviparity1743303oviparity
pacey126720283_pac_ey
pacier105018683_pacier
pacing114522753_pacing
packly17228333_packly
pact86648723_pac_t_
pacts95125803_pac_ts
pacy115328683_pac__y
painty114714753_painty
panty105929303_pa_nty
party106630613_pa_rty
pasty105725053_pa_sty
patty104723613_pa_tty
paty95234563_pa__ty
pity96031933_p__ity
poachy16388963poac_hy
polarity131310403polarity
polity113015863_polity
purity114114913_purity
quality1938563quality
racily11715173_racily
rarity93615493_rarity
raucity1235853raucity
reality10313573reality
repacify1843483repacify
sagacity1445243sagacity
salacity1347853salacity
sanity9316203_sanity
scarcity1545093scarcity
sodality12127323sodality
spacey136212533spac_ey
spacial1138763spacial
spacier114011633spacier
spacing123614493spacing
spacy125415623spac__y
spait75631603spa_it_
spaits85017473spa_its
sparsity1345463sparsity
specify1764993specify
spicily1438653spicily
suavity1336323suavity
tacit76333673_tacit_
tacitly1236223_tacitly
tenacity1347113tenacity
tonality1139793tonality
tonicity1348543tonicity
totality1139373totality
toxicity2045683toxicity
uppity1335103up_pity
vacuity1545763_vacuity
vanity12311933_vanity
veracity1647553veracity
vivacity1943993vivacity
vocality16137933vocality

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.690258972.5
2DLD Change Limit1340271127.18618651.1
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.92222556.3
 
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.