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

178 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
duality114796(None) 
quality1938561quality
anality10313632anality
aurality1139222aurality
dualism1049162dualism
dualist8614052dualist
dualists958242dualists
dualize1759762dualize
dually103210062dual_ly
equality2046992equality
ideality1247152ideality
nullity1037362nullity
orality101111682orality
ovality1377592ovality
qualify2235472qualify
reality10313572reality
rurality1137402rurality
suavity1336312suavity
ability12311443ability
actuality1445803actuality
agility1148653agility
alit46155693__alit_
amity10416093__amity
anility10312723anility
audacity1444823audacity
axiality1856763axiality
banality1338763banality
brutality1444123brutality
burlily1237713burlily
causality1445323causality
cavity14310013_cavity
charity15311023charity
clarity12310913clarity
coalify1536683coalify
curlily1238383curlily
dacite91115883d_acite
dacoity1366183dacoity
daily95922333d_a_ily
dainty105311473d_ainty
dairy97016303d_a_iry
daisy95915313d_a_isy
dakoity1543423dakoity
daleth1038633d_aleth
dally95324743d_al_ly
davit93424593d_avit_
davits104012363d_avits
daylily1434983daylily
daylit10512493daylit_
dealate83617843dealate
dealing94323233dealing
dealt65234283deal_t_
debility1448633debility
deity94316773d__eity
density1137583density
dentality1348473dentality
dialing94318173dialing
dialist8517763dialist
dialists9411413dialists
dicliny1337673dicliny
dignity1236453dignity
dimity12310473d_imity
docility1447123docility
drafty13638933dra_fty
dual55928173dual___
dualisms1147213dualisms
dualistic1246103dualistic
dualities10310443dualities
dualized1937403dualized
dualizes1838823dualizes
duals65620083dual__s
dubiety1344583dubiety
ducally13257413ducal_ly
ductility1544843ductility
dueling93614543dueling
duelist8511413duelist
duelists966003duelists
duit56241583du__it_
duits65021883du__its
dulcify1643023dulcify
dulia61014983du_li_a
dulias71212743du_lias
dulling93418273dulling
dullish1148743dullish
dully94921633du_l_ly
duly85323033du_l__y
dumpily1566233dumpily
dunite7315013du_nite
dunlin739723dunli_n
dunlins849553dunlins
dunnite857333dunnite
duplexity2251893duplexity
duplicity1744663duplicity
durability1647733durability
duskily15236743duskily
dustily113211523dustily
dusty96018323du__sty
duty85321453du___ty
edacity1336373edacity
egalite8311563egalite
falsity1335903_falsity
fatality1438443fatality
faulty12429363faul_ty
fealty122910223feal_ty
feudality1654393feudality
finality1448343finality
frailty1335663frailty
frugality1653263frugality
fugacity1743313fugacity
furmity1535183furmity
futility1446973futility
gravity1437183gravity
guilty10418233guil_ty
halite93624233_halite
humanity1646313humanity
humility1646093humility
hyalite13229473hyalite
inanity1039503inanity
jollity1746143jollity
laity85318903_la_ity
laxity1637273_laxity
lealty92910603leal_ty
legality1237623legality
locality13148433locality
malty106721703_mal_ty
modality14117653modality
molality13118363molality
morality131110333morality
mullite9313013mullite
mutuality1444743mutuality
nasality1146653nasality
natality1139193natality
nodality12127423nodality
nubility1347783nubility
nudity1037993nu_dity
nullify1334713nullify
opacity1436313opacity
outcity1238453outcity
outpity1237493outpity
parity114719873_parity
paucity1435823paucity
penality13310713penality
plurality1444613plurality
polity113015863_polity
purity114114913pu_rity
quakily2336693quakily
qualia1559563quali_a
qualmy20285803qual_my
quantity2044733quantity
rarity93615493_rarity
raucity1235853raucity
realty92713693real_ty
regality1249313regality
ruralite848963ruralite
salify12311373_salify
salty85524383_sal_ty
sanity9316203_sanity
sedulity1245843sedu_lity
sexuality1946073sexuality
sodality12127323sodality
suability1448593suability
sunlit61516103sunlit_
surlily10310003surlily
tonality1139793tonality
totality1139373totality
uglify1333913_uglify
uglily1036193_uglily
unity84918493_u_nity
unlit55025463_unlit_
uplit76020803_uplit_
uppity1335103_uppity
uralite71714103uralite
utility1038703utility
vanity12311933_vanity
vaulty12388443vaul_ty
venality1438683venality
visuality1545443visuality
vitality1458113vitality
vocality16137933vocality

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.390458182.1
2DLD Change Limit1340271786.06322105.7
3Display Results1781780.0632825.4
 (SQL Overall)1786911786.51627423.4
 
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.