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

171 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
upstared1115657(None) 
upsoared11154351upsoared
upstaged12135241upstaged
upstare9158681upstare_
upstares10178581upstares
upstarted1244211upstarted
outstared10188422outstared
stared75429872__stared
unseared91113942unseared
unshared121510702unshared
unstarred1036362unstarred
unstated91615812unstated
unstayed12168392unstayed
upreared1137072upreared
upscaled13144872upscaled
upstage10167442upstage_
upstager11164632upstager
upstages11147372upstages
upstand1045342upsta_nd
upstart9159752upstar_t
upstarts10165272upstarts
upstate91610492upstate_
upstater10156662upstater
upstates10189642upstates
upstirred1241822upstirred
appeared1336143appeared
ascared10399523_ascared
bastard103012423bastar_d
bistered112913333bistered
bistred103311853bist_red
bustard10389723bustar_d
costard104113353costar_d
costarred1244703costarred
custard10389973custar_d
dastard9279703dastar_d
ensnared965293ensnared
estated83715573_estated
festered122512113festered
fostered122210453fostered
gestated102910573gestated
gestured1036993gestured
insnared956123insnared
instarred1043963instarred
instated91613343instated
lustered92510603lustered
lustred8359053lust_red
mastered112614003mastered
mortared1137213mortared
mustard10359533mustar_d
mustered112511503mustered
outsoared10157593outsoared
outstare81410693outstare_
outstares91610183outstares
outstarted1155073outstarted
outstated10169813outstated
outstayed13185933outstayed
oystered1236923oystered
pared86946763_p__ared
pastored1139973pastored
pastured1138233pastured
pestered112814973pestered
petaled103614153_petaled
petard95013803_petar_d
petered103314973_petered
postured1139493postured
pshawed16103033_pshawed
pustuled1134953pustuled
puttered112611143puttered
restaged103011863restaged
restarted10410053restarted
restated93120183restated
restored96417193restored
ruptured1144683rup_tured
scared95227293__scared
seared75232843__seared
shared105829063__shared
sistered92612803sistered
snared74824553__snared
soared74324293__soared
spared95427493__spared
speared104314423sp_eared
staged84521563__staged
staked114621943__staked
staled74728103__staled
staned74824643__staned
stare54440263__stare_
starer64027363__starer
stares66038753__stares
starred85013453__starred
started84217323__started
starved114911573__starved
stated75427833__stated
staved103918053__staved
stayed104817273__stayed
stored75524213__stored
tared69340053___tared
ultrared936663ultrared
unbeared111611653unbeared
unfeared121511013unfeared
unitard838003unitar_d
unsated83419933uns_ated
unsaved113312193uns_aved
unsawed112911503uns_awed
unscaled111410113unscaled
unscarred1235673unscarred
unsealed91513623unsealed
unseamed111210663unseamed
unseated91317683unseated
unshaded13149263unshaded
unshamed14148053unshamed
unshaped14148443unshaped
unshaved15157733unshaved
unslaked1338463unslaked
unsnarled1035743unsnarled
unsoaked1338853unsoaked
unsoured9310063unsoured
unsquared1944073unsquared
unstacked1636433unstacked
unstained1038683unstained
unstalked1435523unstalked
unstamped1454603unstamped
unstate71916213unstate_
unstates81314993unstates
unstoned9311043unstoned
unswayed15155713unswayed
untamed102913223u_ntamed
untaxed152710583u_ntaxed
untired82316383u_ntired
upbearer1243583upbearer
updarted1244313up_darted
updated11369423up_dated
upgazed2033423up_gazed
upgraded13215683upgraded
upheaped1633643upheaped
upheaved1733763upheaved
uphoard1344573uphoar_d
uphoarded1662273uphoarded
upleaped1334333upleaped
uploaded1234533uploaded
uprated103213323up_rated
upscale11136323upscale_
upscales12155993upscales
upsized19246253ups_ized
upsoar8105683upsoar__
upsoars985413upsoar_s
upstagers12173333upstagers
upstair943983upsta_ir
upstairs1043643upstairs
upstands1144093upstands
upstaring1235963upstaring
upstaters11174803upstaters
upstep1035503upst__ep
upstepped1341943upstepped
upstir835383upstir__
upstirs935293upstir_s
upstood1044243upst_ood
upstream1243553upst_ream
upsurged12124043upsurged
uptake1236963up_take_
uptakes1336593up_takes
uptalked1533053up_talked
upthrew1542663up_threw
uptore8279453up_tore_
uptrend1044293up_t_rend
upturned11214013up_turned
upward12147163up_war_d
ushered1139153u_shered
uttered82712433u_ttered
vestured1237463vestured
vistaed1138023vista_ed
westered122511873westered

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621717.93618417.6
3Display Results1711710.0632714.3
 (SQL Overall)1786911718.42221217.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.