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

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
unspoke133657(None) 
unspoken1454241unspoken
bespoke15468112bespoke
outspoke1446492outspoke
respoke134311282respoke
spoke114818662__spoke
unbroke13217742unbroke
unchoke16248192unchoke
unsmoked1536012unsmoked
unspool945162unspool
unswore1039052unswore
unyoke1367292un_yoke
besmoke15416623besmoke
bespake15436963bespake
bespoken16505013bespoken
cowpoke1835103cowpoke
dispose10312763dispose
disyoke1546233disyoke
inshore1038723inshore
insole63515863ins_ole
inspire938253inspire
instroke1245583instroke
invoke1336213in_voke
misspoke1645413misspoke
misyoke1635823misyoke
mopoke1436633_mopoke
muspike1536043muspike
onshore10310013onshore
oospore939013oospore
outsmoke1445753outsmoke
outspoken1544373outspoken
poke105335363___poke
respoken14506923respoken
restoke116113903restoke
smoke115015823__smoke
soke85436263__s_oke
spake114322743__spake
spike114922843__spike
spode84617703__spode
spoked134413893__spoked
spoken124610003__spoken
spokes124417213__spokes
spore75428593__spore
stoke94922513__stoke
sunchoke1744773sunchoke
sunspot947163sunspo_t
sunspots1045083sunspots
sunstone847793sunstone
sunstroke1343203sunstroke
ugsome934783ugs_ome
unalike11311533unalike
unawake1445343unawake
unbrake13239123unbrake
unbroken14235073unbroken
uncake122813523un_cake
unchoked18257623unchoked
unchokes17227273unchokes
unclose91111643unclose
uncooked15269113uncooked
undone7914253un_done
unfroze1945413unfroze
unglove1136103unglove
unhook1347523unhook_
unhooked16286743unhooked
unhooks1436413unhooks
unipod946853unipo_d
unipods1095703unipods
unlike102614063un_like
unloose797863unloose
unmake122811213un_make
unpile81914323un_pile
unposed10711903un_posed
unpure82911533un_pure
unquote1645903unquote
unrobe82611673un_robe
unrove92511683un_rove
unsafe9310693uns_afe
unshaken15175403unshaken
unshod1067603unsho_d
unshorn1036943unshorn
unshowy1644173unshowy
unsicker1435303unsicker
unslaked1338463unslaked
unsoaked1338853unsoaked
unsober967643uns_ober
unsold71410513uns_old
unsowed112511053uns_owed
unsown9328433uns_own
unspeak1344793unspeak
unspeaks1443593unspeaks
unspent92610893unspent
unsphere1355853unsphere
unspilt938853unspilt
unsplit956563unsplit
unspoiled12255563unspoiled
unspoilt1044883unspoilt
unspooled12254913unspooled
unspools1043693unspools
unspotted1244933unspotted
unspun865793unsp_un
unstate71916213unstate
unstocked1645063unstocked
unstoned9311043unstoned
unstop837473unsto_p
unstops936993unstops
unsunk1036333unsunk_
unsure62815413uns_ure
unsworn1046843unsworn
unwove12238883un_wove
unyoked1567123un_yoked
unyokes1466733un_yokes
upslope1144173upslope
upstroke1443993upstroke

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 Filter1786911340270.296603685.8
2DLD Change Limit1340271137.65617506.1
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.99822342.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.