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

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

139 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
obtainabilities196340(None) 
attainabilities1753752attainabilities
stainabilities1655722_stainabilities
obtainability2053553obtainabilit__y
trainabilities1646593_trainabilities
availabilities1955744_availabilities
bankabilities2145904_b_ankabilities
bearabilities1748674_bea_rabilities
cleanabilities1856044clea_nabilities
detachabilities2354144detachabilities
detonabilities1756704det_onabilities
fatigabilities2065374fat_igabilities
germinabilities2084504germinabilities
inabilities13412734____inabilities
machinabilities2473084machinabilities
mailabilities1767694__mailabilities
metastabilities1955494metastabilities
observabilities2293744observabilities
openabilities1748614o__penabilities
repairabilities1955364repairabilities
tenabilities14911484__t_enabilities
tunabilities14138724__t_unabilities
untenabilities1656994unt_enabilities
absorbabilities181675135absorbabilities
actabilities1649985___actabilities
adaptabilities1955625_adaptabilities
admirabilities1956025_admirabilities
advisabilities2055545_advisabilities
affabilities2046945___affabilities
alienabilities1656205_alienabilities
alterabilities1667335alt_erabilities
amenabilities1778835__amenabilities
amiabilities16109875___amiabilities
amicabilities19197895__amicabilities
applicabilities2353735applicabilities
arabilities13413095___a_rabilities
assignabilities1853075assignabilities
attainability18103975attainabilit__y
banalities1249815_b_a_na__lities
believabilities22153945_believabilities
biddabilities1944985_b_iddabilities
breathabilities2253995breathabilities
brushabilities2153965_brushabilities
capabilities1848815__ca_pabilities
castabilities1748795__castabilities
codifiabilities2383035codifi_abilities
coilabilities1748075__coilabilities
comparabilities2374375compa_rabilities
creditabilities2065275creditabilities
cultivabilities2253055cultivabilities
cutabilities1649115cut___abilities
damageabilities2153365damageabilities
decidabilities2046235_decidabilities
deniabilities1649765_deni_abilities
desirabilities1747525_desirabilities
detectabilities2065825detectabilities
deterrabilities1875385deterrabilities
dilatabilities1795935dila_tabilities
disabilities15411105___disabilities
drapabilities1847105_dra_pabilities
drapeabilities1955985_drapeabilities
drinkabilities2155035__drinkabilities
drivabilities1947245__drivabilities
equitabilities2566015_equitabilities
erasabilities1549605_era_sabilities
excitabilities2556315_excitabilities
expandabilities2763875expandabilities
extendabilities2564165extendabilities
extrudabilities2552985extrudabilities
flammabilities2363945_flammabilities
formidabilities2353375formidabilities
friabilities1789155__fri_abilities
habitabilities21125315_habitabilities
hatchabilities2453995hat_chabilities
heritabilities1958195_heritabilities
ignitabilities17106305_ignitabilities
impalpabilities2363955impalpabilities
impassabilities21155245impassabilities
incapabilities2056205inca_pabilities
inevitabilities2055645inevitabilities
insatiabilities1775505insatiabilities
intangibilities1864475intangibilities
integrabilities1885505integrabilities
invariabilities2055125invariabilities
inviabilities1848815_invi_abilities
irritabilities1647295_irritabilities
leachabilities2155535_leachabilities
liabilities13710255___li_abilities
likabilities1877275___likabilities
livabilities1767715___livabilities
manageabilities2053515manageabilities
modifiabilities2382845modifi_abilities
mutabilities1649535mut___abilities
navigabilities2064955_navigabilities
notabilities14410715not___abilities
obtainable1443365obtainab_l___e_
operabilities17510055o__perabilities
opposabilities2054905o_pposabilities
optimalities1654665opt_ima__lities
optionalities1574545optiona__lities
originalities1464885origina__lities
overstabilities2055245overstabilities
packabilities2346555__packabilities
palatabilities1846785pala_tabilities
palpabilities1947245__palpabilities
patentabilities1995335patentabilities
placabilities1947615_pla_cabilities
playabilities2046605_pla_yabilities
pliabilities1649385__pli_abilities
portabilities17410185port___abilities
potabilities16411295pot___abilities
pregnabilities1956545_pregnabilities
printabilities1847275__printabilities
profitabilities2284565profitabilities
readabilities1649305_rea_dabilities
reasonabilities1754665reasonabilities
recallabilities1963955recallabilities
reliabilities15410445_reli_abilities
replicabilities2155105replicabilities
roadabilities1647795_roa_dabilities
salabilities1449605__sa_labilities
separabilities1847345sepa_rabilities
shareabilities1955215_shareabilities
sociabilities1748385_soci_abilities
stabilities13511755_st___abilities
stainability1755655_stainabilit__y
suitabilities1548065__suitabilities
survivabilities2352705survivabilities
tangibilities1655485__tangibilities
testabilities1549935__testabilities
traceabilities1855865_traceabilities
tractabilities1846585_tractabilities
treatabilities1657605trea_tabilities
unsuitabilities1754365unsuitabilities
variabilities1848635__variabilities
viabilities1679675___vi_abilities
washabilities2145985__washabilities
wearabilities1848415_wea_rabilities
wettabilities1847775wet__tabilities

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 Filter178691658740.0931921408.6
2DLD Change Limit658741395.70311550.8
3Display Results1391390.1101263.6
 (SQL Overall)1786911395.90630255.8
 
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.