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

128 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
agility114865(None) 
ability12311441ability
anility10312721anility
vagility1546321vagility
acidity1338592acidity
agilely1135122agilely
algidity1345282algidity
aminity12310512aminity
anality10313632anality
aridity11510112aridity
avidity1436482avidity
axiality1856762axiality
facility1638242facility
fragility1645552fragility
lability13710832lability
utility1038702utility
acidify1645243acidify
acridity1446913acridity
activity1647583activity
acuity1139373a_cuity
affinity1744983affinity
agile65122263agil__e
agilities10810973agilities
agist66325583agi_st_
agists75713173agi_sts
agita6315423ag__ita
agitate8312063agitate
agitato856573agitato
aglet65534143ag_let_
aglets73915683ag_lets
agley96917333ag_l_ey
agly86821803ag_l__y
agouty10366913ag_outy
aiglet74224193aiglet_
aiglets84012913aiglets
ailing74331013a_iling
airily93014823a_irily
alit46155693a__lit_
amenity1238333amenity
amity10416093a__mity
amplify1744083amplify
anilin6417793anili_n
aniline7418473aniline
anilins7416793anilins
animality1447803animality
annuity1045543annuity
anticity13313603anticity
aplite8316393a_plite
arability14411013arability
argillite1044373argillite
atilt54828473atil_t_
aurality1139223aurality
banality1338763banality
basicity1546313basicity
biggity1435013biggity
cagily12411563cagil__y
caninity1338063caninity
civility1646123civility
debility1448633debility
dignity1236453dignity
dimity12310473_dimity
docility1447123docility
duality1147963duality
egalite8311563egalite
fatality1438443fatality
fixity19427803_fixity
futility1446973futility
gaiety10119373gai_ety
gaily95020973gail__y
gaseity1135113gaseity
gaslit7513503gaslit_
gilly94321633_gil_ly
gilt56348543_gil_t_
gilts64924263_gil_ts
glinty106910693_glinty
glitz154916373_g_litz
glitzy19404783_g_litzy
gracility1546203gracility
guilty10418233guil_ty
humility1646093humility
inability14411103inability
jollity1746143jollity
kilty125213893_kil_ty
labiality1446363labiality
latinity1138813latinity
legality1237623legality
liability14128483liability
milty104720073_mil_ty
mobility1548543mobility
motility1338733motility
nasality1146653nasality
natality1139193natality
nativity1446633nativity
nihility1446203nihility
nobility1348983nobility
nubility1347783nubility
nullity1037363nullity
oilily93111723_oilily
orality101111683orality
ovality1377593ovality
polity113015863_polity
privity15268313privity
quality1938563quality
rabidity1446583rabidity
rapidity1446273rapidity
reality10313573reality
regality1249313regality
rigidity1345253rigidity
sagacity1445243sagacity
salinity1138893salinity
sapidity1446433sapidity
senility1139683senility
silty84721633_sil_ty
stability14410083stability
suability1448593suability
tactility1446833tactility
trilith10310513trilith
trinity10310843trinity
twilit949553twilit_
uglify1333913ug_lify
uglily1036193ug_lily
usability1447163usability
validity1545993validity
vapidity1745193vapidity
viability1767873viability
vilify1536773_vilify
virility1447733virility
wilily123310763_wilily

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 Limit1340271285.78323176.0
3Display Results1281280.0304266.7
 (SQL Overall)1786911286.20328807.2
 
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.