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

111 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
constable1331100(None) 
constables1446731constables
castable121613972c_astable
cogitable1446942cogitable
construable1554782construable
consumable1645562consumable
contestable1546892contestable
countable1348852countable
covetable1648162covetable
instable10313202_instable
nonstaple1144922nonstaple
unstable10313762_unstable
boatable121610263bo_atable
bondable13169273bon_dable
bootable12179223bo_otable
canoeable1347093canoeable
cantabile1346893can_tabile
cartable121314093c_artable
cascable141510623c_ascable
cashable15159793c_ashable
causable1239973caus_able
censurable1445653censurable
chantable1636893chantable
chartable1636833chartable
chaseable1646343chaseable
cheatable1646713cheatable
citable11313463c__itable
classable1347143classable
closable12168003clos_able
closeable13155023closeable
coachable1846303coachable
coastal9411043coasta_l_
coastally1446493coastally
codable12311663co__dable
cognizable2443393cognizable
coinable12311583co_inable
colorable1348243colorable
comestible1645423comestible
commutable1845343commutable
computable1855723computable
condonable1545443condonable
confessable1854853confessable
confiscable2053673confiscable
connectable1745713connectable
consignable1654283consignable
console92715983cons__ole
constancy1646023constancy
constant10515593consta_nt
constantly1545183constantly
constants11410913constants
constative15410103constative
construe1049053const_rue
consumables1753203consumables
contrastable1654433contrastable
cookable16147973co_okable
copyable1736623co_pyable
cornstalk1543943cornsta_lk
costae85319683co_sta__e
costal85419513co_sta_l_
costally1339723co_stally
costate94019273co_sta_te
countably1646283countably
coverable1649103coverable
creatable1339563creatable
crossable1347073crossable
crushable1645263crushable
cuttable1247953c_uttable
denotable1238373denotable
doubtable1445163doubtable
gustable11138203_gustable
honorable1446953honorable
huntable1338093hun_table
ignitable1245463ignitable
ionizable2045513ionizable
listable10810313_listable
locatable1345573locatable
losable91910953lo_s_able
mountable1346303mountable
nestable101613673_nestable
nonarable1149053nonarable
nonliable1147673nonliable
nonsalable1245663nonsalable
nonstaples1244323nonstaples
nonstyle1145003nonst_yle
nonusable1146763nonusable
nonviable1446263nonviable
notable92114903__notable
obstacle1243593_obstacle
onstage838363_onsta_ge
pointable1337343pointable
portable12313203po_rtable
posable112212783po_s_able
potable112115363po__table
rentable101716333ren_table
restable101618443_restable
rinsable10310043rins_able
rotatable1146653rotatable
roundtable1383203roundtable
rustable101511363_rustable
sortable10312483so_rtable
stable83921643___stable
tastable101511973_tastable
testable101412623_testable
totable92313363to__table
trustable1147123trustable
twistable1444273twistable
unstabler1145623_unstabler
unstably1339493_unstably
votable122111373vo__table
wastable131410453_wastable
worktable1844723worktable

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.1561145455.1
2DLD Change Limit1486411116.79621871.8
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.99825534.6
 
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.