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

170 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
unsmoked153601(None) 
besmoked17405412besmoked
outsmoked1644772outsmoked
smoked134311722__smoked
unchoked18257622unchoked
uncooked15269112uncooked
unhooked16286742unhooked
unmoved13248902un_moved
unslaked1338462unslaked
unsoaked1338852unsoaked
unsowed112511052uns_owed
unspoke1336572unspoke_
unspoken1454242unspoken
unstocked1645062unstocked
unstoned9311042unstoned
unyoked1567122un_yoked
besmoke15416623besmoke_
besmokes16406363besmokes
disyoked1745463disyoked
enamored1147033enamored
invoked1535303in_voked
mismoved1635653mismoved
misyoked1834623misyoked
nonsmoker1544303nonsmoker
osmosed10134843_osmosed
outsmoke1445753outsmoke_
outsmokes1545313outsmokes
restoked135710533restoked
smocked16398223__smocked
smoke115015823__smoke_
smoker124311693__smoker
smokes124814343__smokes
smokey15398653__smokey
snooked123711493sn_ooked
spoked134413893__spoked
stoked114718293__stoked
unamazed2035883unamazed
unamused1135793unamused
unarmored1244873unarmored
unasked122010023un_asked
unatoned939423unatoned
unavowed1534783unavowed
unawaked1635903unawaked
unbacked17268733unbacked
unbaked143312893un_baked
unblocked1864353unblocked
unboned103014223un_boned
unbooted1188773unbooted
unbowed132610243un_bowed
unboxed17249573un_boxed
unbraked15289413unbraked
unbroke13217743unbroke_
unbroken14235073unbroken
uncaked143514353un_caked
uncasked15278453uncasked
unchoke16248193unchoke_
unchokes17227273unchokes
uncloaked1635653uncloaked
unclosed111010503unclosed
uncloyed1487343uncloyed
uncocked17248753uncocked
uncoded11312743un_coded
uncombed1536323uncombed
uncooled112710633uncooled
uncorked152210403uncorked
undecked16238493undecked
undocked16277633undocked
unfaked153211173un_faked
unforked16218953unforked
unfrocked1944223unfrocked
ungloved1335603ungloved
unhooded13277873unhooded
unhoped13249353un_hoped
unhusked1634603unhusked
unilobed1136393unilobed
unimbued1343073unimbued
uninvoked1742503uninvoked
unironed939083unironed
unkinked12215903unkinked
unlicked15248263unlicked
unliked122411283un_liked
unlinked13237793unlinked
unlobed10219743un_lobed
unlocked15268383unlocked
unloosed9117523unloosed
unloved112310533un_loved
unmake122811213un_make_
unmaker13279513un_maker
unmakes132810793un_makes
unmarked15248813unmarked
unmasked15267143unmasked
unmated103317023un_mated
unmewed13258173un_mewed
unmined102612953un_mined
unmixed17228213un_mixed
unmold9148313un_mo_ld
unmolded1237453un_molded
unmoored1137333unmoored
unnoted8311363un_noted
unpacked17268663unpacked
unpicked17237213unpicked
unplowed1436353unplowed
unposed10711903un_posed
unprobed1366973unprobed
unproved1457533unproved
unquoted1836533unquoted
unraked122914013un_raked
unranked1338563unranked
unrevoked1743423unrevoked
unrobed102711213un_robed
unroofed12106773unroofed
unrooted9810513unrooted
unroped102812103un_roped
unsalted9510923unsalted
unsampled1444443unsampled
unsated83419933uns_ated
unsaved113312193uns_aved
unsawed112911503uns_awed
unscaled111410113unscaled
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unseated91317683unseated
unseeded1038253unseeded
unseized1838443unseized
unserved12410233unserved
unsewed112911023uns_ewed
unsexed152410253uns_exed
unshaded13149263unshaded
unshaken15175403unshaken
unshamed14148053unshamed
unshaped14148443unshaped
unshared121510703unshared
unshaved15157733unshaved
unshed10313773uns__hed
unshod1067603unsho__d
unsicker1435303unsicker
unsifted12128773unsifted
unsigned1037563unsigned
unsized172510543uns_ized
unsliced1138093unsliced
unsmoothed1642003unsmoothed
unsober967643uns_ober
unsoiled92412083unsoiled
unsold71410513uns_o_ld
unsolid8138373uns_olid
unsolved1237833unsolved
unsoothed1344253unsoothed
unsorted9312513unsorted
unsound8158433uns_ound
unsoured9310063unsoured
unspoiled12255563unspoiled
unspooled12254913unspooled
unspotted1244933unspotted
unstacked1636433unstacked
unstalked1435523unstalked
unstated91615813unstated
unstayed12168393unstayed
unstopped1444403unstopped
unsuited9310793unsuited
unswayed15155713unswayed
unswore1039053unswore_
untacked15239923untacked
untucked15206053untucked
unwooded13207443unwooded
unwooed11229773un_wooed
unworked16238503unworked
unyoke1367293un_yoke_
unyokes1466733un_yokes
unzoned172310653un_zoned

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 Limit1461621706.70321805.5
3Display Results1701700.0632698.4
 (SQL Overall)1786911707.20224811.3
 
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.