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

118 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
upsoared1115435(None) 
upstared11156571upstared
outsoared10157592outsoared
soared74324292__soared
unseared91113942unseared
unshared121510702unshared
unsoaked1338852unsoaked
unsoured9310062unsoured
uphoard1344572uphoar_d
uphoarded1662272uphoarded
uploaded1234532uploaded
upreared1137072upreared
upscaled13144872upscaled
upsoar8105682upsoar__
upsoars985412upsoar_s
upstaged12135242upstaged
upstare9158682upstare_
upstares10178582upstares
upstarted1244212upstarted
appeared1336143appeared
ascared10399523_ascared
cupboard1544253cupboar_d
ensnared965293ensnared
insnared956123insnared
oared65030653___oared
outroared10158113outroared
outstared10188423outstared
pared86946763_p__ared
pored85234513_p_o_red
poured95116743_p_oured
pshawed16103033_pshawed
psoae74411623_psoa_e_
resoaked1337943resoaked
roared75015393__roared
scared95227293__scared
seared75232843__seared
shared105829063__shared
snared74824553__snared
soaked114717593__soaked
soaped95817973__soaped
soarer64522243__soarer
sored66141783__so_red
soured74921863__soured
spared95427493__spared
speared104314423sp_eared
spoored104411293sp_oored
spored94821793sp_o_red
stared75429873__stared
ultrared936663ultrared
unbeared111611653unbeared
unboarded13185683unboarded
uncoated11314963uncoated
unfeared121511013unfeared
unloaded1049533unloaded
unmoored1137333unmoored
unsated83419933uns_ated
unsaved113312193uns_aved
unsawed112911503uns_awed
unscaled111410113unscaled
unscarred1235673unscarred
unsealed91513623unsealed
unseamed111210663unseamed
unseated91317683unseated
unshaded13149263unshaded
unshamed14148053unshamed
unshaped14148443unshaped
unshaved15157733unshaved
unslaked1338463unslaked
unsnarled1035743unsnarled
unsoiled92412083unsoiled
unsolved1237833unsolved
unsorted9312513unsorted
unsourced1244833unsourced
unsowed112511053unso_wed
unsquared1944073unsquared
unstarred1036363unstarred
unstated91615813unstated
unstayed12168393unstayed
unswayed15155713unswayed
upbearer1243583upbearer
upboiled13194853upboiled
upbore10247883upbo_re_
upcoiled13215183upcoiled
updarted1244313up_darted
updated11369423up_dated
upfolded1542883upfolded
upgazed2033423up_gazed
upgraded13215683upgraded
upheaped1633643upheaped
upheaved1733763upheaved
uphoards1443763uphoards
upleaped1334333upleaped
upload9257783uploa__d
uprated103213323up_rated
uproar8106933uproar__
uproars986453uproar_s
uprooted1186393uprooted
uproused1135833uproused
upscale11136323upscale_
upscales12155993upscales
upsized19246253ups_ized
upsoaring1244513upsoaring
upstage10167443upstage_
upstager11164633upstager
upstages11147373upstages
upstand1045343upsta_nd
upstart9159753upstar_t
upstarts10165273upstarts
upstate91610493upstate_
upstater10156663upstater
upstates10189643upstates
upstirred1241823upstirred
upsurged12124043upsurged
uptore8279453upto_re_
uptossed1142933uptossed
upward12147163up_war_d
ushered1139153u_shered
visored1138143viso_red

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.420425454.8
2DLD Change Limit1461621187.03320782.3
3Display Results1181180.0931268.8
 (SQL Overall)1786911187.54623680.2
 
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.