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

(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
assignabilities1853081assignabilities_
alienabilities1656224a_lienabilities_
assignability1962874assignabilit___y
assumabilities1853974ass_umabilities_
absorbabilities181675135absorbabilities_
admirabilities1956055admi_rabilities_
advisabilities2055575advi_sabilities_
amenabilities1778845a__menabilities_
amiabilities16109895a_mi__abilities_
amicabilities19197915a_mi_cabilities_
attainabilities1753755attainabilities_
availabilities1955755avai_labilities_
desirabilities1747535desi_rabilities_
fatigabilities2065385fatig_abilities_
ignobilities1555605___ignobilities_
inabilities13412755___i_nabilities_
machinabilities2473085machi_nabilities_
navigabilities2064965navig_abilities_
pregnabilities1956565_pregnabilities_
stainabilities1655735_stainabilities_
suitabilities1548105_sui_tabilities_
trainabilities1646615trai_nabilities_
acceptabilities2354236acceptabilities_
actabilities1649996a___ctabilities_
adaptabilities1955636a_daptabilities_
adjustabilities2563256adjustabilities_
admissibilities2063326admissibilities_
adoptabilities1955276a_doptabilities_
adorabilities1647806a__dorabilities_
affabilities2046946a___ffabilities_
affectabilities2553986affectabilities_
affordabilities2453056affordabilities_
agreeabilities1755346a_greeabilities_
alterabilities1667336a_lterabilities_
analyzabilities2952716analyzabilities_
appealabilities2163886appealabilities_
applicabilities2353746applicabilities_
arabilities13413106a____rabilities_
asininities1145196a_si_n__inities_
assignable1343066assignab_l___e__
associativities2091506associativities_
audibilities1546646audi___bilities_
believabilities22153956believabilities_
biddabilities1944996__biddabilities_
castabilities1748836cas__tabilities_
changeabilities2362866changeabilities_
cleanabilities1856056_cleanabilities_
codifiabilities2383046codifiabilities_
coilabilities1748096_coi_labilities_
damageabilities2153366damageabilities_
decidabilities2046246deci_dabilities_
deniabilities1649786deni__abilities_
detonabilities1756706_detonabilities_
disabilities15411146__di_sabilities_
disposabilities2053546disposabilities_
drillabilities1754806_drillabilities_
drinkabilities2155066_drinkabilities_
drivabilities1947266_dri_vabilities_
driveabilities2055186_driveabilities_
eligibilities1655646_elig_ibilities_
equitabilities2566046equi_tabilities_
excitabilities2556336exci_tabilities_
fishabilities2146326__fishabilities_
forgeabilities2054726_forgeabilities_
friabilities1789176_fri__abilities_
fusibilities1746236fusi___bilities_
germinabilities2084506germinabilities_
habitabilities21125336habi_tabilities_
heritabilities1958216heri_tabilities_
ignitabilities17106336igni_tabilities_
insatiabilities1775506insatiabilities_
insociabilities19105026insociabilities_
instabilities1549886ins__tabilities_
insurabilities1676906ins_urabilities_
integrabilities1885506integrabilities_
inviabilities1848826invi__abilities_
inviolabilities2064326inviolabilities_
irritabilities1647326irri_tabilities_
liabilities13710266__li__abilities_
likabilities1877286__li_kabilities_
livabilities1767726__li_vabilities_
liveabilities1846766__liveabilities_
mailabilities1767716_mai_labilities_
manageabilities2053526manageabilities_
modifiabilities2382856modifiabilities_
observabilities2293746observabilities_
obtainabilities1963406obtainabilities_
openabilities1748626__openabilities_
perishabilities2255326perishabilities_
pliabilities1649406_pli__abilities_
possibilities1756066possi___bilities_
printabilities1847326_printabilities_
punishabilities2253226punishabilities_
reasonabilities1754666reasonabilities_
reliabilities15410466reli__abilities_
resectabilities1956026resectabilities_
resistibilities1753986resistibilities_
risibilities1448646risi___bilities_
salabilities1449616__s_alabilities_
separabilities1847346_separabilities_
severabilities1947436_severabilities_
sewabilities1748936__s_ewabilities_
shareabilities1955216_shareabilities_
sociabilities1748406__sociabilities_
solvabilities1846896__solvabilities_
sorbabilities1746996__sorbabilities_
stabilities13511786__s__tabilities_
suabilities13610816__s__uabilities_
summabilities1975646__summabilities_
tenabilities14911496___tenabilities_
testabilities1549966tes__tabilities_
tunabilities14138746___tunabilities_
unsociabilities19114006unsociabilities_
unsuitabilities1754376unsuitabilities_
untenabilities1657016_untenabilities_
usabilities1369016_us___abilities_
variabilities1848646vari__abilities_
verifiabilities2354446verifiabilities_
viabilities1679686__vi__abilities_
violabilities1856826__violabilities_
visibilities1747386visi___bilities_
washabilities2146016was__habilities_

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 Filter178691658740.0931921408.6
2DLD Change Limit658741226.25010539.8
3Display Results1221220.500244.0
 (SQL Overall)1786911226.84326113.0
 
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.