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

124 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
abilities1171414(None) 
agilities10810971agilities
anilities9516001anilities
labilities12712231labilities
acidities12810182acidities
aminities11312912aminities
analities9715872analities
arabilities13413102arabilities
aridities10911632aridities
avidities13107612avidities
axialities1747732axialities
debilities13411292debilities
facilities1549822facilities
inabilities13412752inabilities
labialities1347032labialities
liabilities13710262liabilities
mobilities1449832mobilities
nobilities12410642nobilities
nubilities1249722nubilities
rabidities1347702rabidities
stabilities13511782stabilities
suabilities13610812suabilities
usabilities1369012usabilities
utilities9610802utilities
vagilities1447952vagilities
viabilities1679682viabilities
ability12311443abilit__y
ablates92416903ab_lat_es
ablatives1445503ab_latives
abolishes1446053abolishes
abolition1147053abolition
abolitions1246653abolitions
acidifies15126453acidifies
acridities1348293acridities
actabilities1649993actabilities
activities1548903activities
acuities10312453a_cuities
affabilities2046943affabilities
affinities1645713affinities
algidities1245953algidities
alibies9313323a__libies
ambiguities1652393ambiguities
amenities11310433amenities
amiabilities16109893amiabilities
amities9317383a__mities
amplifies16106703amplifies
anilines8415143anili_nes
animalities1348993animalities
annuities947463annuities
aplites9314933a_plit_es
audibilities1546643audibilities
auralities10410223auralities
bailies94120203bail__ies
banalities1249813banalities
basicities1446863basicities
bilbies114712343_bil_bies
billies93923503_bil_lies
blites84721213_b_lit_es
blitzes18408703_b_litzes
caninities12410493caninities
capabilities1848823capabilities
civilities1547843civilities
cubicities1646823cubicities
curabilities1649403curabilities
cutabilities1649143cutabilities
dimities11314003_dimities
disabilities15411143disabilities
docilities1349003docilities
dualities10310443dualities
durabilities1549343durabilities
dyeabilities1847873dyeabilities
edibilities1458703edibilities
equabilities2348153equabilities
fatalities1349443fatalities
febrilities1645143febrilities
fixities1838213_fixities
fragilities1547163fragilities
friabilities1789173friabilities
futilities1348863futilities
gracilities1447683gracilities
habilitates1673583habilitates
humilities1547703humilities
jollities1647873jollities
kilties113014143_kil_ties
latinities10410163latinities
likabilities1877283likabilities
livabilities1767723livabilities
lovabilities1788003lovabilities
militias1048633_militias
motilities12410583motilities
movabilities1978363movabilities
mutabilities1649553mutabilities
nasalities1048563nasalities
natalities10410663natalities
nativities1348433nativities
nihilities1348663nihilities
notabilities14410733notabilities
nullities949353nullities
obesities1145843obesities
oralities91214123oralities
ovalities12119803ovalities
pliabilities1649403pliabilities
polities102722343_polities
potabilities16411313potabilities
privities14312043privities
qualities18311223qualities
rapidities1347483rapidities
realities9316313realities
salabilities1449613salabilities
salinities10410953salinities
sapidities1348003sapidities
senilities10312993senilities
sewabilities1748933sewabilities
subtilities1347853subtilities
tactilities1347673tactilities
tenabilities14911493tenabilities
trinities9313343trinities
tunabilities14138743tunabilities
ubieties1046913ubi_eties
ubiquities2143223ubiquities
validities1447303validities
vapidities1646383vapidities
vilifies1439593_vilifies
virilities1379123virilities

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 Filter1786911486410.403443402.0
2DLD Change Limit1486411246.48622917.2
3Display Results1241240.0462695.7
 (SQL Overall)1786911246.93525766.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.