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 “agilities” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
agilities1081097(None) 
abilities11714141abilities
anilities9516001anilities
vagilities1447951vagilities
acidities12810182acidities
algidities1245952algidities
aminities11312912aminities
analities9715872analities
aridities10911632aridities
avidities13107612avidities
axialities1747732axialities
facilities1549822facilities
fragilities1547162fragilities
labilities12712232labilities
utilities9610802utilities
acidifies15126453acidifies
acridities1348293acridities
activities1548903activities
acuities10312453a_cuities
affinities1645713affinities
agility1148653agilit__y
agitates9310883agitat_es
aglitter935093ag_litter
agouties9337693ag_outies
alibies9313323a__libies
amenities11310433amenities
amities9317383a__mities
amplifies16106703amplifies
anilines8415143anili_nes
animalities1348993animalities
annuities947463annuities
aplites9314933a_plit_es
arabilities13413103arabilities
argillites1143483argillit_es
auralities10410223auralities
banalities1249813banalities
basicities1446863basicities
caninities12410493caninities
civilities1547843civilities
debilities13411293debilities
dignities1149593dignities
dimities11314003_dimities
docilities1349003docilities
dualities10310443dualities
egalites9310503egalit_es
fatalities1349443fatalities
fixities1838213_fixities
futilities1348863futilities
gaieties9310183gai_eties
gaseities1047083gaseities
gillies84120963_gil_lies
glitzes17367563_g_litzes
gracilities1447683gracilities
humilities1547703humilities
inabilities13412753inabilities
jollities1647873jollities
kilties113014143_kil_ties
labialities1347033labialities
latinities10410163latinities
legalities1148913legalities
liabilities13710263liabilities
militias1048633_militias
mobilities1449833mobilities
motilities12410583motilities
nasalities1048563nasalities
natalities10410663natalities
nativities1348433nativities
nihilities1348663nihilities
nobilities12410643nobilities
nubilities1249723nubilities
nullities949353nullities
oralities91214123oralities
ovalities12119803ovalities
polities102722343_polities
privities14312043privities
qualities18311223qualities
rabidities1347703rabidities
rapidities1347483rapidities
realities9316313realities
regalities11410593regalities
rigidities1246293rigidities
sagacities1345623sagacities
salinities10410953salinities
sapidities1348003sapidities
senilities10312993senilities
stabilities13511783stabilities
suabilities13610813suabilities
tactilities1347673tactilities
trinities9313343trinities
uglifies1246383ug_lifies
usabilities1369013usabilities
vaginitis1344273vaginiti_s
vaginitises1543393vaginitises
validities1447303validities
vapidities1646383vapidities
viabilities1679683viabilities
vilifies1439593_vilifies
virilities1379123virilities

Search took 9 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 Filter1786911486410.423422437.4
2DLD Change Limit148641987.54619698.0
3Display Results98980.0462130.4
 (SQL Overall)178691988.01522294.6
 
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.