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

137 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
filterabilities2053281filterabilities_
alterabilities1667333_alterabilities_
sinterabilities17114613sinterabilities_
filterability2153694filterabilit___y
integrabilities1885504_integrabilities_
solderabilities1873374solderabilities_
tolerabilities16116604tol_erabilities_
vulnerabilities2053084vulnerabilities_
alienabilities1656205_alienabilities_
believabilities22153945believabilities_
cultivabilities2253055cultivabilities_
deterrabilities1875385_deterrabilities_
dilatabilities1795935dil_atabilities_
enumerabilities1954065enumerabilities_
fatigabilities2065375f_atigabilities_
fishabilities2146285fi__shabilities_
flammabilities2363945f_lammabilities_
flexibilities2564015f_l_exibilities_
forgeabilities2054725forge_abilities_
illegibilities1754405_illegibilities_
insurabilities1676895_insurabilities_
literalities1267545li_tera__lities_
liveabilities1846755li_ve_abilities_
malleabilities1874975malle_abilities_
meltabilities1749865melt__abilities_
operabilities17510055__operabilities_
penetrabilities1965325penetrabilities_
preferabilities2254605preferabilities_
severabilities1947435_severabilities_
tenabilities14911485___tenabilities_
untenabilities1656995_untenabilities_
venerabilities1967355_venerabilities_
actabilities1649986_act__abilities_
admirabilities1956026_admirabilities_
adorabilities1647806__adorabilities_
agreeabilities1755346_agreeabilities_
alterability1747116_alterabilit___y
amenabilities1778836__amenabilities_
arabilities13413096____arabilities_
bearabilities1748676__bearabilities_
biddabilities1944986bi__ddabilities_
castabilities1748796cast__abilities_
cleanabilities1856046_cleanabilities_
coilabilities1748076coil___abilities_
comparabilities2374376comparabilities_
culpabilities1946006cul__pabilities_
curabilities1649386___curabilities_
cutabilities1649116_cut__abilities_
delectabilities2065556delectabilities_
desirabilities1747526_desirabilities_
detectabilities2065826_detectabilities_
detonabilities1756706_detonabilities_
disabilities15411106di___sabilities_
disposabilities2053546disposabilities_
drapeabilities1955986drape_abilities_
drillabilities1754786dril__labilities_
driveabilities2055166drive_abilities_
durabilities1549336___durabilities_
dyeabilities1847866__dye_abilities_
electabilities1857566_electabilities_
extendabilities2564166_extendabilities_
fallibilities1854546fal__libilities_
fertilities1448816f___er_tilities_
filterable1543726filterab_l___e__
formabilities2046996f__ormabilities_
formidabilities2353376formidabilities_
fragilities1547156f____ragilities_
friabilities1789156f___riabilities_
hatchabilities2453996_hatchabilities_
honorabilities1955946_honorabilities_
ignitabilities17106306_ignitabilities_
illegalities1353886_illega__lities_
immovabilities2355296_immovabilities_
immutabilities2056046_immutabilities_
impeccabilities2584726_impeccabilities_
imputabilities2056616_imputabilities_
inabilities13412736_i___nabilities_
incapabilities2056206_incapabilities_
indelibilities1755556_indelibilities_
ineffabilities2256156_ineffabilities_
inexorabilities2454676inexorabilities_
infertilities1656206_infer_tilities_
instabilities1549846_i_nstabilities_
integralities1495506_integra__lities_
internalities1358636_inter_nalities_
invariabilities2055126_invariabilities_
inviabilities1848816_i_nviabilities_
irritabilities1647296_irritabilities_
labilities12712236__l___abilities_
legibilities1547476__l_egibilities_
liabilities13710256__l__iabilities_
liberalities1446256li_bera__lities_
likabilities1877276__l_ikabilities_
livabilities1767716__l_ivabilities_
lovabilities1788006__l_ovabilities_
mailabilities1767696mail___abilities_
marketabilities2353736marketabilities_
measurabilities1964226measurabilities_
memorabilities20137006_memorabilities_
mensurabilities1964416mensurabilities_
mutabilities1649536_mut__abilities_
notabilities14410716_not__abilities_
observabilities2293746_observabilities_
openabilities1748616__openabilities_
palatabilities1846786pal_atabilities_
palpabilities1947246pal__pabilities_
patentabilities1995336_patentabilities_
perdurabilities2074436perdurabilities_
permeabilities2056826perme_abilities_
placabilities1947616_pl_acabilities_
playabilities2046606_pl_ayabilities_
pliabilities1649386_pl__iabilities_
portabilities17410186port__abilities_
potabilities16411296_pot__abilities_
printabilities1847276print__abilities_
quotabilities2466626quot__abilities_
reliabilities15410446rel__iabilities_
renewabilities1956206_renewabilities_
rentabilities15411236rent__abilities_
repairabilities1955366repairabilities_
salabilities1449606sal___abilities_
separabilities1847346_separabilities_
sewabilities1748936___sewabilities_
shareabilities1955216share_abilities_
sinterability1855206sinterabilit___y
solvabilities1846896sol__vabilities_
squeezabilities3562306squeezabilities_
stabilities13511756__st__abilities_
sterilities11129006__ster__ilities_
suitabilities1548066suit__abilities_
testabilities1549936___testabilities_
traceabilities1855866trace_abilities_
tunabilities14138726___tunabilities_
viabilities1679676vi____abilities_
violabilities1856816vi__olabilities_
wearabilities1848416__wearabilities_
wettabilities1847776_wet_tabilities_

Search took 9 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 Limit658741377.7838463.8
3Display Results1371370.1231113.8
 (SQL Overall)1786911377.99922339.2
 
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.