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

172 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
upcasts1118564(None) 
upcast102710091upcast_
casts77237792__casts
dicasts1078702dicasts
outcasts10108682outcasts
pasts75936502_p_asts
recasts93413532recasts
uncases93516552uncases
uncast84215712uncast_
upases84112902up_ases
upcoast1165542upcoast_
updarts1034202updarts
upwafts1541942upwafts
accosts11107993accosts
basts75936933__basts
beasts84519723_beasts
blasts85116773_blasts
boasts85017923_boasts
breasts939703breasts
cants77036943__cants
carts78946293__carts
casas75327843__casas
cases75048383__cases
casks115720063__casks
cast67159903__cast_
caste75932363__caste
castes85631863__castes
casus76419253__casus
cats66356343__ca_ts
cists76624533__cists
clasts84817293_clasts
coasts85719143_coasts
costs77231143__costs
cupcakes1843713cupcakes
cycases1437533cycases
cysts105912773__cysts
decants103514443decants
demasts1089223demasts
dicast9315573dicast_
ducats95011763duca_ts
dumpcarts1641663dumpcarts
durmasts1144093durmasts
dynasts1155103dynasts
easts57530323__easts
encases93116053encases
encysts1244313encysts
epacts105010393ep_acts
fasts86429683__fasts
feasts95116093_feasts
gasts66628633__gasts
hepcats1436473hepca_ts
incants92012803incants
incases93615973incases
incests92711383incests
lasts57731263__lasts
leasts64616413_leasts
locusts9277933locusts
masts77035763__masts
miscasts1238353miscasts
mudcats1236223mudca_ts
muscats1138933musca_ts
nutcases1085793nutcases
oasts56529183__oasts
oblasts947303oblasts
offcasts1643013offcasts
oocysts1243923oocysts
outcast91013743outcast_
outcaste10119613outcaste
outcastes11118903outcastes
outfasts11117233outfasts
outlasts8108713outlasts
oxcarts1634313oxcarts
pacts95125803_p_acts
pants76536923_p_ants
parts77743373_p_arts
pases75346503_p_ases
pass65239953_p_as_s
past65959013_p_ast_
pasta76624533_p_asta
pastas85422873_p_astas
paste74932953_p_aste
pastes85233913_p_astes
pastis84924323_p_astis
pasty105725053_p_asty
pats66460853_p_a_ts
peases85229473_peases
peats76140193_pea_ts
pests75933273_p_ests
phases114618403_phases
phasis114614923_phasis
plaits83816473_plaits
plants84921803_plants
plasms103711333_plasms
plats75531373_pla_ts
posts75228783_p_osts
prases84429023_prases
prats76333393_pra_ts
precasts1239453precasts
prests84021263_prests
purists94014073purists
racists92613323racists
recants93217093recants
recast83422773recast_
repasts93611933repasts
roasts64915413_roasts
scants85219723_scants
scarts85321493_scarts
scats75930603_sca_ts
scatts85914663_scatts
secants93413893secants
spaits85017473sp_aits
spasms10418973sp_asms
spats75031383sp_a_ts
splats84817303spla_ts
sprats85819933spra_ts
subcaste1287853subcaste
subcastes1387493subcastes
tipcarts1244573tipcarts
tipcats1137103tipca_ts
toasts65914993_toasts
topmasts1244973topmasts
typecasts1642823typecasts
ukases10358063u_kases
umlauts943193umlauts
uncages103213773uncages
uncakes133012743uncakes
uncaps1039813unca_ps
uncase83817433uncas_e
uncased104216953uncased
unchaste1346923unchaste
unclasps1244573unclasps
uneases73316263uneases
unhasty1344283unhasty
unhats91110623unha_ts
unmasks1344553unmasks
unplaits1044813unplaits
unrests7229463unrests
upas68322383up_a__s
upbeats1195733upbeats
upcasting1434823upcasting
upcoils1184933upcoils
upcurls1143653upcurls
updart9310743updart_
update93810293upda_te
updates10329793updates
updrafts1443203updrafts
upgazes1933573upgazes
uplands1036943uplands
uplifts12424773uplifts
upmost1068193upmost_
upraises10188473upraises
uprate83916543upra_te
uprates93814863uprates
uprises92012733uprises
uproots937143uproots
upscales12155993upscales
upsets8409683up_sets
upshots1235193upshots
upstarts10165273upstarts
uptakes1336593uptakes
uptalks1333723uptalks
uptilts934733uptilts
uptoss836093uptos_s
upwaft1444943upwaft_
upwards13135963upwards
urases63723563u_rases
ureases74416723ureases
utmosts934593utmosts
vasts86423773__vasts
wasts87433673__wasts
webcasts1543313webcasts
yeasts96413053_yeasts

Search took 7 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.406440125.6
2DLD Change Limit1340271726.51620568.9
3Display Results1721720.0632730.2
 (SQL Overall)1786911726.98525582.1
 
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.