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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

176 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
livability188674(None) 
liability14128481li_ability
likability1996121likability
liveability1945791liveability
lovability18106921lovability
disability1649762disability
drivability2046772drivability
inability14411092_inability
lability13710832l__ability
movability2077222movability
pliability1748042pli_ability
viability1767872vi_ability
ability12311443___ability
actability1749073actability
affability2145673affability
alienability1745683alienability
amiability1748713amiability
amicability2047303amicability
arability14411003_arability
believability2353753believability
biddability2043843biddability
capability1947583capability
civility1646123civ__ility
coilability1847923coilability
cultivability2373683cultivability
curability1747853curability
cutability1747863cutability
driveability2155073driveability
durability1647723durability
dyeability1945883dyeability
eligibility1754823eligibility
equability2446743equability
fishability2245273fishability
friability1847883friability
inviability1978733inviability
labiality1446363l__abiality
legibility1645913legibility
livabilities1767713livabilities
lividity1545083liv__idity
mailability1847283mailability
mutability1748073mutability
notability1549693notability
placability2047123placability
playability2146003playability
potability1749793potability
reliability1649453reli_ability
risibility1547533risibility
salability1548513salability
sewability1846853sewability
solvability1946403solvability
stability14410083_stability
suability1448593_suability
suitability1647113suitability
tenability1549123tenability
tunability1546983tunability
usability1447163_usability
vagility1546323__vagility
violability1946263violability
visibility1846473visibility
admirability2055694admirability
adorability1746874adorability
advisability2155054advisability
agility1148654___agility
alterability1747114alterability
amenability1847474amenability
anility10312724___anility
applicability24114064applicability
audibility1645824audibility
availability2055474availability
bankability2245234bankability
bearability1847324bearability
castability1848394castability
cleanability1955214cleanability
culpability2045294culpability
debility1448634__debility
decidability2145744decidability
deliverability23102674deliverability
deniability1748724deniability
desirability1847254desirability
dilatability1845444dilatability
disutility1454614disutility
divinity1546164div__inity
divisibility2153934divisibility
drapability1986454drapability
drillability1854614drillability
drinkability2254674drinkability
edibility1546914_edibility
educability1946244educability
electability1947054electability
equitability2645774equitability
erasability1668904erasability
excitability2655674excitability
facility1638244__facility
fatigability2154984fatigability
finality1448344fina__lity
fissility1544604fi_ssility
flammability2453864flammability
flexibility2653294flexibility
formability2146934formability
fragility1645554_fragility
fusibility1845704fusibility
gracility1546194_gracility
habitability2255084habitability
heritability2047974heritability
ignitability1856034ignitability
ignobility1654144ignobility
immobility1945324immobility
immovability2454834immovability
instability1649434instability
inutility1246214_inutility
invalidity1753024invalidity
irritability1747454irritability
juvenility2351874juvenility
latinity1138814l__atinity
leachability2255244leachability
legality1237624lega__lity
liabilities13710254li_abilities
liberality1545904liberality
likabilities1877274likabilities
limpidity1743384li_mpidity
lineality1246424li_neality
liquidity2243834li_quidity
literality1346904literality
livable122010324livab_l__e
liveabilities1846754liveabilities
livelily1444104liv__elily
locality13148434loca__lity
lovabilities1788004lovabilities
lovably15187064lovab_l__y
malleability1954844malleability
meltability1848684meltability
miscibility2055454miscibility
mobility1548544__mobility
navigability2155434navigability
nihility1446204ni__hility
nobility1348984__nobility
nubility1347784__nubility
openability1846924openability
operability1848844operability
ovality1377594_ova__lity
packability2446024packability
palatability1946364palatability
palpability2046314palpability
portability1849534portability
printability1946844printability
probability2047674probability
quotability2555584quotability
rabidity1446584__rabidity
readability1748044readability
removability2255724removability
rentability16410184rentability
replicability2255594replicability
reusability1648464reusability
roadability1757164roadability
severability2046744severability
sociability1847914sociability
solubility1545274solubility
sorbability1846354sorbability
stainability1755664stainability
summability2045434summability
survivability2453174survivability
testability1648804testability
tolerability1776284tolerability
trainability1746824trainability
validity1545994__validity
vapidity1745194__vapidity
variability1947504variability
virility1447734__virility
vitality1458114vita__lity
vivacity1943994viva__city
volatility1644864volatility
volubility1844414volubility
washability2245304washability
wearability1947094wearability
wettability1946484wettability
workability2345364workability

Search took 10 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 Filter1786911614500.1701051123.5
2DLD Change Limit1614501769.33017304.4
3Display Results1761760.0931892.5
 (SQL Overall)1786911769.59318627.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.