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

113 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
undefinable174638(None) 
indefinable1756351indefinable
definable1547772__definable
indefinables1853122indefinables
indefinably2055172indefinably
undecidable1745722undecidable
undeniable1348562undeni_able
undesirable1447482undesirable
definably1845653__definably
indeclinable1794843indeclinable
refinable1438623__refinable
undebatable1644973undebatable
undeniably1646493undeni_ably
undependable1853923undependable
undesirables1553313undesirables
undesirably1755353undesirably
undrinkable1853573und_rinkable
unfindable1644863un__findable
unifiable1447343un_ifi_able
unlearnable1344973unlearnable
unreliable1248483unreli_able
untenable11410503unte__nable
condemnable1854054conde_mnable
decidable1547224__decidable
declinable1545864__declinable
defendable1754984__defendable
demisable1448534__demisable
deniable11312084__deni_able
derivable1548064__derivable
desirable1249394__desirable
detonable1247624__detonable
devisable1546854__devisable
drainable1237584__drainable
finable122213624____finable
inclinable1447714in_clinable
indefatigable2061984indefatigable
indefensible18104084indefensible
indefinite1454424indefin_ite
indelible1246844indeli__ble
indexable1947034inde__xable
indomitable1645994indomitable
indubitable1654244indubitable
ineffable17105794in_ef_fable
inevitable1557644in_evitable
inheritable1647244inheritable
interminable1656894interminable
medicinable1852454medicinable
modifiable1852204modifi_able
unalienable1345344unalienable
unamenable1446944un_amenable
unamiable1348474un_ami_able
unattainable1453394unattainable
unavailable1654684unavailable
unavoidable1753764unavoidable
unbearable1447384unbe_arable
unbeatable1447834unbe_atable
unbelievable1952844unbelievable
unbendable1545814unbe_ndable
unburnable1444574un_burnable
undanceable1654404undanceable
undatable1238984und__atable
undauntable1474214undauntable
undebatably1953444undebatably
undefiled1446114undefi___led
undefined1445874undefin__ed
undeliverable1962064undeliverable
underfinanced2061324underfinanced
undescribable2062484undescribable
undetectable1754574undetectable
undeterminable1962754undeterminable
undoable1139054und___oable
undoubtable1653574undoubtable
uneatable11311694un_e_atable
unedible1146414un_edi__ble
uneducable1545784un_educable
unenviable1545854un_enviable
unexcitable2245064unexcitable
unflyable1744634un__flyable
unhirable1447644un__hirable
unimaginable1753074unimaginable
unlikable1546774un__likable
unlivable1447604un__livable
unmemorable1754834unmemorable
unmentionable1753674unmentionable
unmixable2045864un__mixable
unobtainable1653344unobtainable
unopenable1466074un_openable
unpliable1347814un_pli_able
unprintable1555214un_printable
unprofitable1953614unprofitable
unreachable1846094unreachable
unreadable1347714unre_adable
unrealizable2354304unrealizable
unreasonable1454734unreasonable
unremovable1854564unremovable
unreturnable1453644unreturnable
unreviewable2052604unreviewable
unridable1248294un__ridable
unseasonable1454264unseasonable
unseeable1149454unse__eable
unsellable1247094unse_llable
unsinkable1645094un__sinkable
unsociable1447284unsoci_able
unsuitable1247574un_suitable
unteachable1845744unteachable
untenably1447534unte__nably
untestable1248824unte_stable
unthinkable2053094un_thinkable
untunable1147834un__tunable
unverifiable2053284unverifiable
unviable1338704un__vi_able
unwearable1547214unwe_arable
unwinnable1544094un_winnable

Search took 9 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.423422437.4
2DLD Change Limit1488191138.37617767.3
3Display Results1131130.0601883.3
 (SQL Overall)1786911138.85920170.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.