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

79 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
viabilities167968(None) 
liabilities13710261liabilities
abilities11714142__abilities
amiabilities16109892amiabilities
arabilities13413102arabilities
disabilities15411142disabilities
friabilities1789172friabilities
inabilities13412752inabilities
inviabilities1848822inviabilities
labilities12712232_labilities
likabilities1877282likabilities
livabilities1767722livabilities
pliabilities1649402pliabilities
stabilities13511782stabilities
suabilities13610812suabilities
usabilities1369012usabilities
vagilities1447952v_agilities
variabilities1848642variabilities
violabilities1856822violabilities
virilities1379122vi_rilities
visibilities1747382visibilities
actabilities1649993actabilities
advisabilities2055573advisabilities
affabilities2046943affabilities
agilities10810973__agilities
amicabilities19197913amicabilities
anilities9516003__anilities
availabilities1955753availabilities
biddabilities1944993biddabilities
capabilities1848823capabilities
civilities1547843ci_vilities
coilabilities1748093coilabilities
curabilities1649403curabilities
cutabilities1649143cutabilities
debilities13411293_debilities
deniabilities1649783deniabilities
drivabilities1947263drivabilities
durabilities1549343durabilities
dyeabilities1847873dyeabilities
edibilities1458703edibilities
equabilities2348153equabilities
facilities1549823_facilities
fishabilities2146323fishabilities
fissilities1445643fissilities
fragilities1547163fragilities
gracilities1447683gracilities
labialities1347033_labialities
liveabilities1846763liveabilities
lovabilities1788003lovabilities
mailabilities1767713mailabilities
mobilities1449833_mobilities
movabilities1978363movabilities
mutabilities1649553mutabilities
navigabilities2064963navigabilities
nihilities1348663ni_hilities
nobilities12410643_nobilities
notabilities14410733notabilities
nubilities1249723_nubilities
potabilities16411313potabilities
rabidities1347703_rabidities
reliabilities15410463reliabilities
risibilities1448643risibilities
salabilities1449613salabilities
sewabilities1748933sewabilities
sociabilities1748403sociabilities
suitabilities1548103suitabilities
tenabilities14911493tenabilities
tunabilities14138743tunabilities
validities1447303v_alidities
vapidities1646383v_apidities
viability1767873viabilit__y
vicinities1547463vi_cinities
virginities1544023virginities
viridities14106903vi_ridities
viscidities1744473viscidities
visualities1446553visualities
vitalities1349093vi_talities
volatilities1546513volatilities
volubilities1745123volubilities

Search took 6 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 Filter1786911216330.390458182.1
2DLD Change Limit121633795.00024326.6
3Display Results79790.0461717.4
 (SQL Overall)178691795.43632871.8
 
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.