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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
extractable225415(None) 
exactable2046432ex__actable
extraditable2253052extraditable
extricable2144742extric_able
intractable1557362intractable
retractable1545122retractable
tractable1338512__tractable
abstractable1852193abstractable
distractable1753603distractable
embraceable1952083embraceable
enactable1338493e__nactable
erectable131210093e__rectable
expectable2345063ex_pectable
extractive2246603extract_ive
extrudable2073083extr_udable
intractably1856663intractably
titratable1243693titra_table
traceable1338323__traceable
trackable1736743__trackable
tractably1646243__tractably
untraceable1546853untraceable
actable11313474____actable
attachable1743194_attachable
attractance1552064attractance
contractible1854664contractible
contrastable1654434contrastable
correctable1745234correctable
destructible1752784destructible
detachable1844614det_achable
detectable15136604det_ectable
distractible1763544distractible
draftable1575564__draftable
eatable91717604e___a_table
effaceable2042264e_ffaceable
ejectable20136574e__jectable
electable13149624e__lectable
equatable2045194e_qua_table
erasable10511044e__ra_sable
excitable2056244ex__citable
execrable2046234ex__ecrable
executable2144034ex_ecutable
exercisable2252774exercisable
exorable1738934exor___able
expandable2243124ex_pandable
expectably2654224ex_pectably
explainable2252524explainable
explicable2344344explic_able
exploitable2262694exploitable
exportable2144604ex_portable
extendable2043834ext_endable
extract16311014extract____
extractability28103554extractability
extracted1946724extract__ed
extracting2047224extract_ing
extraction1967984extract_ion
extractions2077744extractions
extractively2754534extractively
extractives2354554extractives
extractor1846724extract__or
extractors1946424extract_ors
extracts1747624extract___s
extricate1869074extric_a_te
getatable1235954get_a_table
grantable1257294__grantable
inextricable2393454inextric_able
metastable1444924met_astable
ratable91717554___ra_table
restartable1343544rest_artable
restrainable1452804restrainable
retractile1246254retract_ile
retrainable1344354retrainable
rotatable1146654rot_a_table
stackable1735994_st_ackable
statable10310704_st_a_table
tastable101511974__t_astable
teachable16137604__teachable
traceably1646224__traceably
tractate10411004__tracta_te
tractile10311074__tract_ile
tradable1139874__tra_dable
tradeable1247414__tradeable
trainable1138944__trainable
treatable1139324__treatable
truckable1744514__truckable
trustable1147124__trustable
unactable13310054__unactable
unteachable1845744unteachable
warrantable1662304warrantable

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.440406115.9
2DLD Change Limit148819889.07616397.0
3Display Results88880.0332666.7
 (SQL Overall)178691889.54918713.1
 
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.