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 “chartable” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
chartable163683(None) 
cartable121314091c_artable
chantable1636891chantable
charitable1744641charitable
castable121613972c_astable
chargeable1843472chargeable
charitably2043462charitably
chaseable1646342chaseable
cheatable1646712cheatable
hatable121713962_ha_table
sharable131910692shar_able
shareable1436732shareable
abatable1238023aba_table
actable11313473__actable
adaptable1444613adaptable
alarmable1345013alarmable
arable81821003__ar_able
avertable14117343avertable
awardable1543953awardable
barrable1249243_barrable
bearable121512363bear_able
beatable121612243bea_table
boardable1444893boardable
boatable121610263boa_table
callable12310753c_allable
cantabile1346893c_antabile
capable13313363c_a_pable
carpale113414353c_arpa_le
cartage10312593c_arta_ge
cascable141510623c_ascable
cashable15159793c_ashable
causable1239973c_ausable
chaetae1238603chaeta__e
chaetal1238283chaeta_l_
changeable1843963changeable
chantage1446633chanta_ge
charade13129913char_a_de
chasuble1543063cha_suble
checkable2244743checkable
chelatable1743603chelatable
chewable1835443ch_ewable
chippable2073353chippable
chokeable2053853chokeable
chorale124313353chor_a_le
chortle124210443chort__le
citable11313463c__itable
claimable1545703claimable
classable1347143classable
clearable1346013clear_able
coachable1846303coachable
cogitable1446943cogitable
constable13311003constable
countable1348853countable
covetable1648163covetable
creatable1339563creatable
curable112414513c_ur_able
curbable1447663c_urbable
cuttable1247953c_uttable
datable101714233_da_table
draftable1575563draftable
eatable91717603_ea_table
enactable1338493enactable
exactable2046433exactable
farmable1538203_farmable
grantable1257293grantable
habitable1645953_habitable
hackable1937473_hackable
hangable1438213_hangable
hartal9415473_harta_l_
hartals10313023_harta_ls
hateable1339373_hateable
hearable131611603hear_able
heatable131612043_heatable
heritable1439453_heritable
hirable121612313_hir_able
hireable13139083_hireable
hittable1336853_hittable
huntable1338093_huntable
inarable10313133inar_able
learnable1145563learnable
parable111819773_par_able
parsable12311693_parsable
partible1238063_partible
plantable1337273plantable
portable12313203_portable
ratable91717553_ra_table
shakable17177683sha_kable
shakeable1844943shakeable
shamable15168803sha_mable
shameable1645573shameable
shapable15197803sha_pable
shapeable1645743shapeable
shavable16177273sha_vable
shiftable1744893shiftable
sortable10312483_sortable
sparable121611983spar_able
spareable1337263spareable
statable10310703sta_table
tastable101511973_tastable
tearable101512673tear_able
tractable1338513tractable
unactable13310053unactable
uncharitable1984023uncharitable
variable13310063_variable
wastable131410453_wastable
wearable131510553wear_able

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 Filter1786911486410.403443402.0
2DLD Change Limit1486411066.42323142.0
3Display Results1061060.0462304.3
 (SQL Overall)1786911066.87226002.8
 
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.