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

169 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
anility1031272(None) 
ability12311441ability
agility1148651agility
anality10313631anality
acidity1338592acidity
aminity12310512aminity
anilin6417792anili_n
aniline7418472aniline
anilins7416792anilins
animality1447802animality
annuity1045542annuity
anticity13313602anticity
aridity11510112aridity
avidity1436482avidity
axiality1856762axiality
banality1338762banality
caninity1338062caninity
facility1638242facility
lability13710832lability
senility1139682senility
utility1038702utility
vagility1546322vagility
acidify1645243acidify
acridity1446913acridity
activity1647583activity
acuity1139373a_cuity
affinity1744983affinity
agilely1135123agilely
ailing74331013a_iling
airily93014823a_irily
algidity1345283algidity
alit46155693a__lit_
amenity1238333amenity
amity10416093a__mity
amplify1744083amplify
analcite1049333analcite
anally9513503anal_ly
analogy11177853analogy
analyte10158813analyte
aneling82719503aneling
anglice1089213anglice
angling92816043angling
angrily1137723angrily
anil46437433anil___
anile54634463anil__e
anilines8415143anilines
anilities9516003anilities
anils56326723anil__s
animacy1446103animacy
animate91617213animate
animato91610623animato
animi74016663animi__
animis84615943animi_s
animism113510213animism
animist93815173animist
animists103010633animists
animosity1445253animosity
anisic8313793anisi_c
anklet105618733anklet_
anklets114310413anklets
ankling122912063ankling
anolyte10159003anolyte
antielite9411603antielite
antilife11410433antilife
antilogy1248103antilogy
antiquity2145813antiquity
antlike11312073antlike
antlion7310293antlion
anviling1239743anviling
anxiety1744033anxiety
aplite8316393a_plite
arability14411013arability
asininity1243473asininity
atilt54828473atil_t_
atonality1247073atonality
atonicity1456223atonicity
aurality1139223aurality
basicity1546313basicity
carnality1447593carnality
civility1646123civility
conicity15411093conicity
debility1448633debility
dimity12310473_dimity
docility1447123docility
duality1147963duality
enmity1137483en_mity
entity9312053en_tity
fatality1438443fatality
finality1448343finality
fixity19427803_fixity
fragility1645553fragility
futility1446973futility
geniality1347163geniality
gentility1347063gentility
gracility1546203gracility
guilty10418233guil_ty
humility1646093humility
inability14411103inability
inanity1039503inanity
infinity1447313infinity
iniquity2044473iniquity
inutility1246213inutility
ionicity1348823ionicity
jollity1746143jollity
kilty125213893_kil_ty
labiality1446363labiality
lanosity1146353lanosity
latinity1138813latinity
liability14128483liability
manlily1238743man_lily
milty104720073_mil_ty
mobility1548543mobility
motility1338733motility
nailing83419963nailing
naivety1344283naivety
nasality1146653nasality
natality1139193natality
nativity1446633nativity
nicety1138433_nicety
nidify1336763_nidify
nifty115211633_ni_fty
nighty135611273_nighty
nihility1446203nihility
nimiety1244633_nimiety
ninety9510963_ninety
nitty85418313_ni_tty
nobility1348983nobility
nubility1347783nubility
nudity1037993_nudity
nullity1037363nullity
oilily93111723_oilily
orality101111683orality
ovality1377593ovality
penality13310713penality
polity113015863_polity
privity15268313privity
quality1938563quality
rabidity1446583rabidity
rancidity1544313rancidity
rapidity1446273rapidity
reality10313573reality
salinity1138893salinity
sanctity1345593sanctity
sanity9316203san__ity
sapidity1446433sapidity
silty84721633_sil_ty
stability14410083stability
suability1448593suability
tactility1446833tactility
tensility1245803tensility
tonality1139793tonality
tonicity1348543tonicity
trilith10310513trilith
trinity10310843trinity
twilit949553twilit_
unanimity1443703unanimity
unity84918493un__ity
unlit55025463un_lit_
usability1447163usability
validity1545993validity
vanity12311933van__ity
vapidity1745193vapidity
venality1438683venality
veniality1547593veniality
viability1767873viability
vilify1536773_vilify
virility1447733virility
wilily123310763_wilily
zanily18310183zanil__y

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.420425454.8
2DLD Change Limit1340271696.64320175.7
3Display Results1691690.0602816.7
 (SQL Overall)1786911697.12325086.5
 
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.