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

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

119 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
correctable174523(None) 
collectable17104902collectable
connectable1745712connectable
correlatable1652542correlatable
uncorrectable1963392uncorrectable
collectables18103353collectables
collectible17104513collectible
connectible1755253connectible
contestable1546893contestable
corrective1747443correct_ive
correctly1644963correct__ly
corruptible1753083corruptible
covetable1648163co_ve_table
creatable1339563c__reatable
erectable131210093__erectable
forfeitable1962783forfeitable
forgettable1752103forgettable
projectable2452903projectable
affectable2043614_affectable
appreciable1953844appreciable
cartable121314094c_ar__table
charitable1744644char_itable
chartable1636834char__table
cheatable1646714c__heatable
checkable2244744c__heckable
coachable1846304co__achable
coarctate1344824coar_cta_te
coercible1544874coer_c_ible
cogitable1446944co__gitable
collectibles1883614collectibles
colorectal1453154colorecta_l_
comestible1645424co_mestible
comfortable2093644comfortable
commendable2054344commendable
committable1953494committable
commutable1845344co_mmutable
compactible2153654compactible
compellable1953374compellable
compensable1955194compensable
computable1855724co_mputable
concealable1755054concealable
conceivable2054994conceivable
conceptacle1674364conceptacle
condemnable1854054condemnable
condensable16115394condensable
conductible1854464conductible
conferrable1845824conferrable
confessable1854854confessable
constable13311004co__nstable
contractible1854664contractible
contrastable1654434contrastable
conversable1846354conversable
convertible1846234convertible
correct11513984correct____
corrected1438114correct__ed
correcter1348104correct__er
correctest1445604correct_est
correcting15199304correct_ing
correction1448814correct_ion
corrections1548864corrections
correctitude1761214correctitude
correctively2254864correctively
correctives1845574correctives
correctness1553814correctness
corrector1347604correct__or
correctors1447494correct_ors
corrects1259574correct___s
correlate1149044corre_la_te
correlative1645544correlative
corrigible1552814corr_igible
corrodible1552944corr_odible
corruptibly2052494corruptibly
countable1348854co__untable
coverable1649104co_ve_rable
creditable1546004c_reditable
crunchable1942514c_runchable
deflectable1943804deflectable
delectable15247384_delectable
depreciable1854554depreciable
detectable15136604_detectable
ejectable20136574__ejectable
electable13149624__electable
expectable2345064_expectable
extractable2254154extractable
fermentable1844074fermentable
forceable1646214fo_r_ceable
forecastable1982094fo_recastable
forgeable1545404forge__able
harvestable1951864harvestable
inflectable1845124inflectable
injectable2147004_injectable
intractable1557364intractable
irrecusable1554054_irrecusable
irrefutable1653984_irrefutable
irremeable1444704_irremeable
irritable1148054_irr_itable
marketable1843224marke_table
nonreusable1354714nonreusable
orderable1246184_orde_rable
perfectible2053434perfectible
pocketable2043594pocke_table
portable12313204po_r__table
prosecutable1851794prosecutable
regrettable1452984regrettable
rentable101716334___rentable
resectable1478124_resectable
respectable1755044respectable
restable101618444___restable
retable91820404___re_table
retractable1545124retractable
selectable14136444_selectable
sortable10312484so_r__table
targetable1383874targe_table
torchable1645534to_r_chable
tractable1338514__tractable
treatable1139324__treatable
unelectable1546754unelectable
warrantable1662304warrantable
worktable1844724wo_r_ktable

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit1488191199.11016335.8
3Display Results1191190.0631888.9
 (SQL Overall)1786911199.59318627.2
 
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.