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

103 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
chantable163689(None) 
chartable1636831chartable
cantabile1346892c_antabile
cartable121314092c_artable
castable121613972c_astable
changeable1843962changeable
chantage1446632chanta_ge
charitable1744642charitable
chaseable1646342chaseable
cheatable1646712cheatable
countable1348852countable
grantable1257292grantable
hangable1438212_hangable
hatable121713962_ha_table
huntable1338092_huntable
plantable1337272plantable
abatable1238023aba_table
actable11313473__actable
adaptable1444613adaptable
bankable1677913_bankable
bannable1278353_bannable
beatable121612243bea_table
boatable121610263boa_table
callable12310753c_allable
canoeable1347103c_anoeable
cantabiles1445763c_antabiles
cantal84122033c_anta_l_
cantala94114673c_anta_la
cantals93919573c_anta_ls
canticle1239703c_anticle
cantle84522153c_ant__le
capable13313363c_a_pable
cascable141510623c_ascable
cashable15159793c_ashable
causable1239973c_ausable
chaetae1238603chaeta__e
chaetal1238283chaeta_l_
chandelle1545223chandelle
changeably2152993changeably
chantages1546583chantages
chanteuse1443473chanteuse
chargeable1843473chargeable
charitably2043463charitably
chasuble1543063cha_suble
checkable2244743checkable
chelatable1743603chelatable
chewable1835443ch_ewable
chippable2073353chippable
chokeable2053853chokeable
citable11313463c__itable
claimable1545703claimable
classable1347143classable
cleanable1345203clean_able
coachable1846303coachable
cogitable1446943cogitable
coinable12311583coin_able
constable13311003constable
countably1646293countably
covetable1648163covetable
creatable1339563creatable
cuttable1247953c_uttable
datable101714233_da_table
draftable1575563draftable
eatable91717603_ea_table
enactable1338493enactable
exactable2046433exactable
frankable1844923frankable
habitable1645953_habitable
hackable1937473_hackable
hantle94318203_hant__le
hateable1339373_hateable
heatable131612043_heatable
hittable1336853_hittable
loanable1037613loan_able
merchantable2152023merchantable
mountable1346303mountable
paintable1337243paintable
pointable1337343pointable
printable1338203printable
ratable91717553_ra_table
rentable101716333_rentable
sandable111612823_sandable
scannable1345643scannable
shakable17177683sha_kable
shakeable1844943shakeable
shamable15168803sha_mable
shameable1645573shameable
shapable15197803sha_pable
shapeable1645743shapeable
sharable131910693sha_rable
shareable1436733shareable
shavable16177273sha_vable
shiftable1744893shiftable
shunnable1443203shunnable
statable10310703sta_table
tannable1039383_tannable
tastable101511973_tastable
tenantable1244183tenantable
thinkable1844063thinkable
tractable1338513tractable
turntable1144983turntable
unactable13310053unactable
wastable131410453_wastable

Search took 8 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.423422437.4
2DLD Change Limit1486411036.62622433.0
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.09525185.5
 
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.