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

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

111 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
undoable113905(None) 
undouble1145441undouble
doable93115242__doable
unable83819222un__able
undatable1238982undatable
undocile1145952undocile
undoubled1344232undoubled
undoubles1243922undoubles
unlovable1446362unlovable
unmovable1645962unmovable
unstable10313762unstable
unusable1038952unusable
unviable1338702unviable
addable11218843_addable
adorable1138773_adorable
beddable14166923beddable
bendable131510853bend_able
biddable14165673biddable
bindable13169623bind_able
bondable13169273bond_able
boundable1444843bound_able
codable12311663cod_able
condonable1545443condonable
double94013993__double
dowable13189453__dowable
dyable12308983__dyable
enable83318483en__able
encodable1446273encodable
endorsable1344583endorsable
endurable1247733endurable
enjoyable2143743enjoyable
ennoble935633enno_ble
enviable1337853enviable
erodable1139203erodable
fadable13310463fad_able
findable14179023find_able
gnawable1435683gnawable
guidable1236203guid_able
hidable1399403hid_able
huntable1338093hun_table
inarable10313133inarable
indexable1947033indexable
indocile1146703indocile
indole74516053indo__le
instable10313203instable
inviable1338523inviable
knowable1745043knowable
lendable11169463lend_able
mendable131510583mend_able
munchable1844943munchable
namable11312343_namable
nobble103814313_n_obble
noble74420993_n_o_ble
notable92114903_notable
radiable11611303radiable
redouble1145523redouble
ridable101412493rid_able
rideable1158653rideable
roundtable1383203roundtable
sandable111612823sand_able
sendable111612043send_able
soundable1245983sound_able
subduable1444143subduable
tunable92511313tun__able
tuneable1038913tun_eable
unactable13310053unactable
unadoptable1653533unadoptable
unamiable1348473unamiable
unbale83616403un_ba_le
unbottle1044223unbottle
uncapable1547783uncapable
uncobbled1643663uncobbled
uncouple1245753uncouple
uncurable13710073uncurable
undeniable1348563undeniable
undone7914253undo__ne
undoubtable1653573undoubtable
undoubted1344463undoubted
undrape1049333undra_pe
uneatable11311693uneatable
unedible1146413unedible
uneducable1545783uneducable
unflyable1744633unflyable
unhirable1447643unhirable
unifiable1447343unifiable
unknowable1943513unknowable
unlikable1546773unlikable
unlivable1447603unlivable
unmixable2045863unmixable
unnamable1356623unnamable
unpliable1347813unpliable
unprovable1745713unprovable
unridable1248293unridable
unrobe82611673unro_b_e
unsalable1148993unsalable
unsayable1447223unsayable
unseeable1149453unseeable
unsociable1447283unsociable
unsolvable1545083unsolvable
unstabler1145623unstabler
unstably1339493unstably
untamable1347843untamable
untenable11410503untenable
untunable1147833untunable
unworkable1944473unworkable
usable84012553u__sable
useable9911063u_seable
vendable14159693vend_able
wadable13310233wad_able
wadeable1437443wadeable
windable14159153wind_able

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621117.26620115.9
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.74823062.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.