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

113 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
damageabilities215336(None) 
manageabilities2053512manageabilities
damageability2253173damageabilit__y
drapeabilities1955983d_rapeabilities
adaptabilities1955624_adaptabilities
admirabilities1956024adm_irabilities
agreeabilities1755344_agreeabilities
amenabilities1778834_am_enabilities
amiabilities16109874_am__iabilities
amicabilities19197894_am_icabilities
availabilities1955744_availabilities
changeabilities2362864changeabilities
detachabilities2354144detachabilities
dilatabilities1795934dila_tabilities
drapabilities1847104d_ra_pabilities
driveabilities2055164d_riveabilities
dyeabilities1847864d___yeabilities
fatigabilities2065374fatig_abilities
forgeabilities2054724_forgeabilities
mailabilities1767694__mailabilities
malleabilities1874974ma_lleabilities
navigabilities2064954navig_abilities
palatabilities1846784pala_tabilities
shareabilities1955214_shareabilities
traceabilities1855864_traceabilities
actabilities1649985___actabilities
adjustabilities2563235adjustabilities
admissibilities2063275admissibilities
adoptabilities1955265_adoptabilities
adorabilities1647805_a_dorabilities
advisabilities2055545_advisabilities
affabilities2046945___affabilities
alienabilities1656205_alienabilities
alterabilities1667335_alterabilities
analyzabilities2952715_analyzabilities
arabilities13413095___a_rabilities
assignabilities1853075assignabilities
assumabilities1853975_assumabilities
attainabilities1753755attainabilities
bankabilities2145905__bankabilities
bearabilities1748675_bea_rabilities
breathabilities2253995breathabilities
capabilities1848815__ca_pabilities
castabilities1748795__castabilities
cleanabilities1856045clea_nabilities
coagulabilities2062725_coagulabilities
comparabilities2374375comparabilities
computabilities2354535computabilities
debilities13411295d____e_bilities
decidabilities2046235d_ecidabilities
delectabilities2065555delectabilities
deniabilities1649765d__eniabilities
dependabilities2155245dependabilities
desirabilities1747525d_esirabilities
detectabilities2065825detectabilities
deterrabilities1875385deterrabilities
detonabilities1756705d_etonabilities
disabilities15411105d___isabilities
disposabilities2053545disposabilities
drillabilities1754785d_rillabilities
drinkabilities2155035d_rinkabilities
drivabilities1947245d__rivabilities
durabilities1549335d___urabilities
erasabilities1549605_era_sabilities
expandabilities2763875expandabilities
flammabilities2363945_flammabilities
habitabilities21125315ha_bitabilities
hatchabilities2453995ha_tchabilities
immovabilities2355295_immovabilities
immutabilities2056045_immutabilities
impalpabilities2363955impalpabilities
impassabilities21155245impassabilities
imputabilities2056615_imputabilities
incapabilities2056205inca_pabilities
insatiabilities1775505insatiabilities
integrabilities1885505integrabilities
invariabilities2055125invariabilities
leachabilities2155535_leachabilities
liveabilities1846755__liveabilities
machinabilities2473085machinabilities
magnanimities1891555__magnanimities
manageability2153905manageabilit__y
marketabilities2353735marketabilities
meltabilities1749865__meltabilities
memorabilities20137005mem_orabilities
metastabilities1955495metastabilities
movabilities1978365__m_ovabilities
mutabilities1649535__m_utabilities
obtainabilities1963405obtainabilities
packabilities2346555__packabilities
palpabilities1947245__palpabilities
patentabilities1995335patentabilities
permeabilities2056825_permeabilities
placabilities1947615_pla_cabilities
playabilities2046605_pla_yabilities
pregnabilities1956545_pregnabilities
readabilities1649305_rea_dabilities
recallabilities1963955recallabilities
remediabilities2054615remediabilities
removabilities2186315rem_ovabilities
repairabilities1955365repairabilities
roadabilities1647795_roa_dabilities
salabilities1449605__sa_labilities
separabilities1847345sepa_rabilities
stainabilities1655725_stainabilities
summabilities1975625sum__mabilities
tangibilities1655485ta_ng_ibilities
tractabilities1846585_tractabilities
trainabilities1646595_trainabilities
treatabilities1657605trea_tabilities
variabilities1848635__variabilities
washabilities2145985__washabilities
wearabilities1848415_wea_rabilities

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 Limit658741135.01613132.8
3Display Results1131130.0931215.1
 (SQL Overall)1786911135.20234350.4
 
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.