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

125 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
expendabilities2774371expendabilities_
expandabilities2763872expandabilities_
extendabilities2564162extendabilities_
dependabilities2155243dependabilities_
excludabilities27102414excludabilities_
expansibilities2693384expansibilities_
expendability2853844expendabilit___y
exportabilities2654564exportabilities_
extensibilities2493464extensibilities_
extrudabilities2552984extrudabilities_
openabilities1748614_open_abilities_
alienabilities1656205alien_abilities_
amenabilities1778835_amen_abilities_
appealabilities2163885appealabilities_
deniabilities1649765__deniabilities_
electabilities1857565e_lectabilities_
employabilities2463125employabilities_
excitabilities2556315ex_citabilities_
expandability2853685expandabilit___y
expendables2352155expendab_l___es_
extendability2653595extendabilit___y
impeccabilities2584725impeccabilities_
operabilities17510055_ope_rabilities_
patentabilities1995335patentabilities_
readabilities1649305__readabilities_
refundabilities2153925refundabilities_
rentabilities15411235__rentabilities_
repeatabilities1955915repeatabilities_
spreadabilities2054005spreadabilities_
tenabilities14911485__ten_abilities_
untenabilities1656995unten_abilities_
vendibilities1955875__vendibilities_
acceptabilities2354226acceptabilities_
affectabilities2553986affectabilities_
affordabilities2453056affordabilities_
agreeabilities1755346agre_eabilities_
alterabilities1667336alte_rabilities_
applicabilities2353736applicabilities_
bankabilities2145906__bankabilities_
bearabilities1748676__bearabilities_
believabilities22153946belie_vabilities_
biddabilities1944986__biddabilities_
bipedalities17123636bipe_da__lities_
capabilities1848816cap___abilities_
cleanabilities1856046_cleanabilities_
countabilities1856666_countabilities_
credibilities1856066_cre_dibilities_
decidabilities2046236_decidabilities_
defensibilities2164046defensibilities_
delectabilities2065556delectabilities_
dependability2254866dependabilit___y
detectabilities2065826detectabilities_
deterrabilities1875386deterrabilities_
detonabilities1756706deton_abilities_
drapeabilities1955986drape__abilities_
drinkabilities2155036_drinkabilities_
dyeabilities1847866_dye__abilities_
edibilities1458706___e_dibilities_
educabilities1857066e__ducabilities_
enumerabilities1954066enumerabilities_
equabilities2348156___equabilities_
equitabilities2566016e_quitabilities_
erasabilities1549606e__rasabilities_
erodibilities1656886e__rodibilities_
expansivities2582486expan__sivities_
expendable2243876expendab_l___e__
externalities2055186externa__lities_
formidabilities2353376formidabilities_
germinabilities2084506germin_abilities_
hypermobilities2763426hypermobilities_
impalpabilities2363956impalpabilities_
impassabilities21155246impassabilities_
implacabilities2354016implacabilities_
improbabilities23114296improbabilities_
improvabilities24114476improvabilities_
imputabilities2056616imp_utabilities_
inabilities13412736___in_abilities_
ineffabilities2256156_ineffabilities_
insensibilities1764906insensibilities_
integrabilities1885506integrabilities_
liveabilities1846756live__abilities_
meltabilities1749866__meltabilities_
observabilities2293746observabilities_
opposabilities2054906_opposabilities_
packabilities2346556__packabilities_
palpabilities1947246__palpabilities_
penalities121313446__pen_a__lities_
penetrabilities1965326penetrabilities_
perdurabilities2074436__perdurabilities_
permeabilities2056826__permeabilities_
placabilities1947616__placabilities_
playabilities2046606__playabilities_
pliabilities1649386__p_liabilities_
portabilities17410186__portabilities_
potabilities16411296__p_otabilities_
pregnabilities1956546_pregnabilities_
printabilities1847276_printabilities_
probabilities1958076__probabilities_
reasonabilities1754666reason_abilities_
reliabilities15410446__reliabilities_
remediabilities2054616remediabilities_
renewabilities1956206__renewabilities_
repairabilities1955366repairabilities_
replicabilities2155106replicabilities_
reputabilities1847426rep_utabilities_
resectabilities1956016resectabilities_
reusabilities1549266__reusabilities_
roadabilities1647796__roadabilities_
sensibilities1557366__sensibilities_
separabilities1847346sep_arabilities_
severabilities1947436seve_rabilities_
sewabilities1748936__se_wabilities_
squeezabilities3562306squeezabilities_
stainabilities1655726stain_abilities_
testabilities1549936__testabilities_
tolerabilities16116606tole_rabilities_
trainabilities1646596train_abilities_
treatabilities1657606_treatabilities_
tunabilities14138726__tun_abilities_
unreliabilities1754786unreliabilities_
upgradabilities2162466upgradabilities_
venerabilities1967356__venerabilities_
vulnerabilities2053086vulnerabilities_
wearabilities1848416__wearabilities_
wettabilities1847776__wettabilities_

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 Limit658741255.04613054.7
3Display Results1251250.1101136.4
 (SQL Overall)1786911255.24934042.9
 
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.