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

106 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
unalienable134534(None) 
inalienable1354721inalienable
alienable1146932__alienable
inalienably1654032inalienably
unalterable1345772unalterable
unamenable1446942una_menable
inalterable1355223inalterable
inclinable1447713incli_nable
lienable10188693___lienable
unalienated1244013unalienated
unalterably1654423unalterably
unamiable1348473unami__able
unbelievable1952843unbelievable
unclimbable1953063unclimbable
unlikable1546773un_li_kable
unlistenable1453023un_listenable
unlivable1447603un_li_vable
unopenable1466073un_openable
unpliable1347813unpli__able
untenable11410503un__tenable
unwinnable1544093un_winnable
alienage945584__aliena_ge
alienate8311554__aliena_te
alterable1149164__alterable
amenable1238864__a_menable
analyzable2452674anal_yzable
believable1742724_believable
declinable1545864decli_nable
drainable1237584dra_i_nable
examinable2144094exami_nable
gainable1138934_ga_i_nable
imaginable1544294imagi_nable
inalterably1654564inalterably
laminable1337124_lami_nable
linable92214344___li_nable
lineable101811084___lineable
malleable1376074_malle_able
nameable1238864_na_me_able
navigable1544744_navi_gable
qualifiable2551884qualifiable
realizable2145334reali_zable
relievable1544664_relievable
saleable10312024_sal_e_able
stainable1138094sta_i_nable
trailerable1352824trailerable
trainable1138944tra_i_nable
unacceptable20103604unacceptable
unactable13310054una__ctable
unadaptable1653914unadaptable
unadoptable1653534unadoptable
unanswerable1753124unanswerable
unappealable1852994unappealable
unappeasable1853404unappeasable
unarguable1344834una_rguable
unattainable1453394unattainable
unavailable1654684unavailable
unavoidable1753764unavoidable
unbelievably2262144unbelievably
unbendable1545814un__bendable
unbuildable1652504unbuildable
unburnable1444574un_burnable
unchewable2044274un_chewable
unclubbable1682384unclubbable
undanceable1654404undance_able
undefinable1746384undefinable
undeliverable1962064undeliverable
undeniable1348564un__deniable
undependable1853924undependable
undrinkable1853574undrinkable
unelectable1546754unelectable
unfalsifiable2161924unfalsifiable
unfashionable21102434unfashionable
unfindable1644864un_findable
unflappable2053054unflappable
unflyable1744634unfl__yable
ungovernable1852764ungovernable
unhirable1447644un_hi_rable
unifiable1447344un__ifiable
unilineal943924unilinea_l_
unimaginable1753074unimagi_nable
unlearnable1344974unlearnable
unlovable1446364un_l_ovable
unmarketable2052464unmarketable
unmixable2045864un_mi_xable
unnameable1445504unname_able
unpalatable1544794unpal_atable
unpardonable1752994unpardonable
unpatentable1653684unpatentable
unplayable1745314unpl_ayable
unprintable1555214unprintable
unrealizable2354304unreali_zable
unreliable1248484unreli__able
unreviewable2052604unreviewable
unridable1248294un_ri_dable
unsalable1148994unsal___able
unseeable1149454un__seeable
unsinkable1645094un_sinkable
unslakable1645234unsl_akable
unsuitable1247574unsui_table
untenably1447534un__tenably
unthinkable2053094unthinkable
untillable1245984un_tillable
untunable1147834un__tunable
unutterable1354054unutterable
unviable1338704un_vi__able
utilizable2152994utili_zable

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 Limit1488191068.22018104.5
3Display Results1061060.0601766.7
 (SQL Overall)1786911068.70320532.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.