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

181 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
anality1031363(None) 
anility10312721anility
banality1338761banality
ability12311442ability
agility1148652agility
analcite1049332analcite
anally9513502anal_ly
analogy11177852analogy
analyte10158812analyte
animality1447802animality
annuity1045542annuity
atonality1247072atonality
aurality1139222aurality
axiality1856762axiality
carnality1447592carnality
duality1147962duality
fatality1438442fatality
finality1448342finality
inanity1039502inanity
nasality1146652nasality
natality1139192natality
orality101111682orality
ovality1377592ovality
penality13310712penality
quality1938562quality
reality10313572reality
tonality1139792tonality
venality1438682venality
aalii5316133a_ali_i
aaliis6312903a_aliis
acidity1338593acidity
actuality1445803actuality
acuity1139373a_cuity
alacrity1355483alacrity
alit46155693__alit_
alkalify1842823alkalify
amanita9310453amanita
amenity1238333amenity
aminity12310513aminity
amity10416093__amity
amorality1446723amorality
amplify1744083amplify
anaclitic1346503anaclitic
anagogy12174443anagogy
anal48037523anal___
analcime1245393analcime
analcites1147483analcites
analecta1045733analecta
analects1047703analects
analgia898363analgia
analgias9107803analgias
analities9715873analities
analog7159973anal_og
analogs82810453analogs
analyse10208893analyse
analyst10189323analyst
analysts11167443analysts
analytes11169203analytes
analytic1348183analytic
analyze19167013analyze
anarchy1544933anarchy
anatomy1246233anatomy
anatto6139913ana_tto
aneling82719503aneling
anglice1089213anglice
angling92816043angling
angrily1137723angrily
anilin6417793anili_n
aniline7418473aniline
anilins7416793anilins
anklet105618733anklet_
anklets114310413anklets
ankling122912063ankling
annalist8413753annalist
annalists949063annalists
anolyte10159003anolyte
anticity13313603anticity
antlike11312073antlike
antlion7310293antlion
anxiety1744033anxiety
apatite9312963apatite
aplite8316393a_plite
arability14411013arability
aridity11510113aridity
audacity1444823audacity
avidity1436483avidity
await85524493awa_it_
awaits96411953awa_its
banalize191010933banalize
banally1249223banal_ly
calamity1547753calamity
canaling112016413canaling
canalise10816213canalise
canalize19914493canalize
caninity1338063caninity
capacity1746023capacity
causality1445323causality
cavity14310013_cavity
charity15311023charity
clarity12310913clarity
coalify1536683coalify
dentality1348473dentality
edacity1336373edacity
egalite8311563egalite
enmity1137483en_mity
entity9312053en_tity
equality2046993equality
facility1638243facility
falsity1335903_falsity
fayalite1447053fayalite
fealty122910223feal_ty
frailty1335663frailty
geniality1347163geniality
gnatty10336483gna_tty
gravity1437183gravity
halite93624233_halite
hyalite13229473hyalite
ideality1247153ideality
inability14411103inability
insanity1147333insanity
jollity1746143jollity
labiality1446363labiality
lability13710833lability
laity85318903_la_ity
lanosity1146353lanosity
laxity1637273_laxity
lealty92910603leal_ty
legality1237623legality
lineality1246423lineality
locality13148433locality
malty106721703_mal_ty
mammality1544283mammality
manlily1238743man_lily
mentality1449133mentality
minacity1547373minacity
modality14117653modality
molality13118363molality
morality131110333morality
nasty85717283_na_sty
natty85719143_na_tty
nazify2134233_nazify
nodality12127423nodality
nudity1037993_nudity
nullity1037363nullity
opacity1436313opacity
parity114719873_parity
penalty1267743penal_ty
planarity1445323planarity
polity113015863_polity
qualify2235473qualify
rapacity1544983rapacity
rarity93615493_rarity
rascality1445993rascality
realty92713693real_ty
regality1249313regality
rurality1137403rurality
sagacity1445243sagacity
salacity1347853salacity
salify12311373_salify
salty85524383_sal_ty
sanctity1345593sanctity
sanity9316203_sanity
senility1139683senility
snakily1436913snakily
sodality12127323sodality
suavity1336313suavity
tantalite91010863tantalite
tenacity1347113tenacity
totality1139373totality
unakite1138743unakite
unalike11311533unalike
unity84918493un__ity
unlit55025463un_lit_
unreality1246323unreality
uralite71714103uralite
utility1038703utility
vagility1546323vagility
vanity12311933_vanity
veniality1547593veniality
vitality1458113vitality
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.406440125.6
2DLD Change Limit1340271816.84319586.0
3Display Results1811810.0802262.5
 (SQL Overall)1786911817.32924381.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.