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

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

99 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
deputable148704(None) 
reputable1379121reputable
debatable1446312debatable
deletable12149502deletable
denotable1238372denotable
depletable1544972depletable
deportable1545652deportable
deposable1446832deposable
disputable1545062disputable
imputable1546682imputable
refutable1477862refutable
reputably1686452reputably
adaptable1444613adap_table
adoptable1444753adop_table
beatable121612243be_atable
computable1855723computable
datable101714233d__atable
debatably1754213debatably
debutante1243223debutante
decayable1745623decayable
decidable1547223decidable
deducible1543393deducible
deductible1643203deductible
definable1547773definable
delayable1546063delayable
delectable15247383delectable
delegable13136643delegable
demisable1448533demisable
demountable1652573demountable
deniable11312083de_niable
dependable1645793dependable
deplorable1545073deplorable
deployable1843863deployable
depurate1139983depura_te
depute94512303deput___e
deputize2045423deput_ize
derivable1548063derivable
desirable1249393desirable
despicable1744983despicable
detectable15136603detectable
detestable13136503detestable
detonable1247623detonable
devisable1546853devisable
dilatable1246853dilatable
dippable1536123dip_pable
disputably1853963disputably
disreputable1752763disreputable
doubtable1445163doubtable
draftable1575563draftable
dubitable1445093dubitable
dupable12238383d__upable
durable102312723d__urable
dutiable1137373d__utiable
eatable91717603_e_atable
editable11310423_editable
educable1337093_educable
equable1849253_equ_able
equatable2045193_equatable
equitable2046193_equitable
evitable1339323_evitable
executable2144033executable
getable101712553ge__table
getatable1235953getatable
gettable11178133ge_ttable
heatable131612043he_atable
heritable1439453heritable
immutable1545593immutable
imputably1845343imputably
meltable12310473me_ltable
mutable11312303__mutable
nestable101613673ne_stable
nettable101610243ne_ttable
permutable1644983permutable
perusable1347453perusable
pettable121710713pe_ttable
potable112115363__potable
rebuttable1443953rebuttable
refusable1476683refusable
refutably1785333refutably
regulable1246513regulable
relatable11310053relatable
rentable101716333re_ntable
reparable1359953reparable
repayable1666343repayable
repeatable1447603repeatable
reportable1446953reportable
restable101618443re_stable
resumable1347553resumable
retable91820403re__table
reusable10811273re_usable
scrutable1346043scrutable
securable1347773securable
separable1348673separable
temptable1545813temptable
tenurable1147423tenurable
testable101412623te_stable
vegetable1545683vegetable
veritable1448743veritable
wettable13148043we_ttable

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.423422437.4
2DLD Change Limit148641996.36023371.2
3Display Results99990.0601650.0
 (SQL Overall)178691996.84326113.0
 
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.