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

122 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
assignabilities185308(None) 
alienabilities1656223a_lienabilities
assignability1962873assignabilit__y
assumabilities1853973ass_umabilities
absorbabilities181675134absorbabilities
admirabilities1956054admi_rabilities
advisabilities2055574advi_sabilities
amenabilities1778844a__menabilities
amiabilities16109894a_mi__abilities
amicabilities19197914a_mi_cabilities
attainabilities1753754attainabilities
availabilities1955754avai_labilities
desirabilities1747534desi_rabilities
fatigabilities2065384fatig_abilities
ignobilities1555604___ignobilities
inabilities13412754___i_nabilities
machinabilities2473084machi_nabilities
navigabilities2064964navig_abilities
pregnabilities1956574_pregnabilities
stainabilities1655734_stainabilities
suitabilities1548104_sui_tabilities
trainabilities1646614trai_nabilities
acceptabilities2354235acceptabilities
actabilities1649995a___ctabilities
adaptabilities1955635a_daptabilities
adjustabilities2563255adjustabilities
admissibilities2063325admissibilities
adoptabilities1955275a_doptabilities
adorabilities1647805a__dorabilities
affabilities2046945a___ffabilities
affectabilities2553985affectabilities
affordabilities2453055affordabilities
agreeabilities1755345a_greeabilities
alterabilities1667335a_lterabilities
analyzabilities2952715analyzabilities
appealabilities2163885appealabilities
applicabilities2353745applicabilities
arabilities13413105a____rabilities
asininities1145195a_si_n__inities
assignable1343065assignab_l___e_
associativities2091505associativities
audibilities1546645audi___bilities
believabilities22153955believabilities
biddabilities1944995__biddabilities
castabilities1748835cas__tabilities
changeabilities2362865changeabilities
cleanabilities1856055_cleanabilities
codifiabilities2383045codifiabilities
coilabilities1748095_coi_labilities
damageabilities2153365damageabilities
decidabilities2046245deci_dabilities
deniabilities1649785deni__abilities
detonabilities1756705_detonabilities
disabilities15411145__di_sabilities
disposabilities2053545disposabilities
drillabilities1754805_drillabilities
drinkabilities2155065_drinkabilities
drivabilities1947265_dri_vabilities
driveabilities2055185_driveabilities
eligibilities1655645_elig_ibilities
equitabilities2566045equi_tabilities
excitabilities2556335exci_tabilities
fishabilities2146325__fishabilities
forgeabilities2054725_forgeabilities
friabilities1789175_fri__abilities
fusibilities1746235fusi___bilities
germinabilities2084505germinabilities
habitabilities21125335habi_tabilities
heritabilities1958215heri_tabilities
ignitabilities17106335igni_tabilities
insatiabilities1775505insatiabilities
insociabilities19105025insociabilities
instabilities1549885ins__tabilities
insurabilities1676905ins_urabilities
integrabilities1885505integrabilities
inviabilities1848825invi__abilities
inviolabilities2064325inviolabilities
irritabilities1647325irri_tabilities
liabilities13710265__li__abilities
likabilities1877285__li_kabilities
livabilities1767725__li_vabilities
liveabilities1846765__liveabilities
mailabilities1767715_mai_labilities
manageabilities2053525manageabilities
modifiabilities2382855modifiabilities
observabilities2293745observabilities
obtainabilities1963405obtainabilities
openabilities1748625__openabilities
perishabilities2255325perishabilities
pliabilities1649405_pli__abilities
possibilities1756065possi___bilities
printabilities1847325_printabilities
punishabilities2253225punishabilities
reasonabilities1754665reasonabilities
reliabilities15410465reli__abilities
resectabilities1956025resectabilities
resistibilities1753985resistibilities
risibilities1448645risi___bilities
salabilities1449615__s_alabilities
separabilities1847345_separabilities
severabilities1947435_severabilities
sewabilities1748935__s_ewabilities
shareabilities1955215_shareabilities
sociabilities1748405__sociabilities
solvabilities1846895__solvabilities
sorbabilities1746995__sorbabilities
stabilities13511785__s__tabilities
suabilities13610815__s__uabilities
summabilities1975645__summabilities
tenabilities14911495___tenabilities
testabilities1549965tes__tabilities
tunabilities14138745___tunabilities
unsociabilities19114005unsociabilities
unsuitabilities1754375unsuitabilities
untenabilities1657015_untenabilities
usabilities1369015_us___abilities
variabilities1848645vari__abilities
verifiabilities2354445verifiabilities
viabilities1679685__vi__abilities
violabilities1856825__violabilities
visibilities1747385visi___bilities
washabilities2146015was__habilities

Search took 5 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.313570897.8
2DLD Change Limit658741223.92316791.7
3Display Results1221220.0931311.8
 (SQL Overall)1786911224.32941277.7
 
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.