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

184 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
upbeats119573(None) 
upbears1195421upbears
upbeat10911511upbeat_
beats76042242__beats
peats76140192_p_eats
pleats85218592_pleats
unbears998042unbears
unbelts9237662unbelts
unseats73012852unseats
upbear1096492upbea_r
upheaps1494232upheaps
upleaps1185232upleaps
uprears9107492uprears
upsets8409682upse_ts
uptears9106452uptears
abets75621673_abe_ts
apneas83211383apnea_s
appeals11378673appeals
appears11308953appears
bats66962333__b_ats
beads85429503__beads
beaks115326623__beaks
beams95328173__beams
beans75734693__beans
bears75739043__bears
beast76338643__beast
beasts84519723__beasts
beat66168303__beat_
beaus75127113__beaus
beauts86015283__beauts
beets76131443__beets
belts75931163__belts
bents76033693__bents
bests75932613__bests
betas75528763__betas
bets67051443__be_ts
blats75132503__blats
bleats85518613_bleats
bluebeats1343463bluebeats
boats75635153__boats
bobcats1335993bobcats
brats75336013__brats
bugbears1333693bugbears
bumboats1445183bumboats
caveats1239803caveats
cheats114519543_cheats
cleats84919313_cleats
cudbears1343483cudbears
debeaks1436103debeaks
defeats113511233defeats
drumbeats1442323drumbeats
eats47054873___eats
ebbets10376833ebbe_ts
eupneas935233eupnea_s
feats86432753__feats
greats76318393_greats
gunboats1144823gunboats
heats85838403__heats
meats75034053__meats
miseats92815783miseats
neats55931903__neats
numbats1137673numb_ats
nutmeats1044463nutmeats
obeahs1135863_obeahs
offbeats1682813offbeats
orgeats838353orgeats
outbeams1236063outbeams
outbleats1144393outbleats
outeats72215703outeats
paeans85118263_paeans
pats66460853_p__ats
peags86122843_p_eags
peaks114825623_p_eaks
peals75235493_p_eals
peans75437643_p_eans
pears75138613_p_ears
peas65755063_p_ea_s
peat65967933_p_eat_
peaty105725693_p_eaty
pelts76128813_p_elts
pests75933273_p_ests
pets66248333_p_e_ts
pietas84516503_pietas
plats75531373_p_lats
pleads94613953_pleads
pleas75627033_plea_s
pleat74734473_pleat_
poets76024443_poe_ts
prats76333393_p_rats
preacts113211363_preacts
prests84021263_prests
puberty1444783puberty
pubes94423403pube__s
puppets10317013puppe_ts
rabats83116223rab_ats
reheats104513523reheats
repeats94316053repeats
reseats74319583reseats
sabbats1138633sabbats
seats54844343__seats
spats75031383sp__ats
speaks125114583sp_eaks
speans85417143sp_eans
spears84019473sp_ears
spelts84614643sp_elts
splats84817303sp_lats
splents93912133splents
sprats85819933sp_rats
spreads1039763spreads
sunbeams1243963sunbeams
sunbelts1044673sunbelts
sweats94814613_sweats
teats55636813__teats
threats104311673threats
treats64821693_treats
tugboats11154103tugboats
umbels104510593umbe_ls
umbers104215213umbe_rs
umbras1038643umbra_s
unbans81912623unb_ans
unbars82113033unb_ars
unbear889163unbea_r
unbeaten1038013unbeaten
unbelt83015693unbelt_
unbends10236993unbends
unbent83216593unbent_
unbolts9247803unbolts
unhats91110623u_nhats
unleads8228623unleads
unrests7229463unrests
unseals73212573unseals
unseams9338913unseams
unseat64221023unseat_
unsets64116163unse_ts
upas68322383up__a_s
upbearer1243583upbearer
upbearers1343033upbearers
upbinds12234813upbinds
upboils1184703upboils
upbows1384683upb_ows
upbraid1244973upbraid
upbraids1343553upbraids
upcast102710093up_cast
upcasts11185643upcasts
upcoast1165543upcoast
updarts1034203updarts
update93810293up_date
updates10329793up_dates
updrafts1443203updrafts
upends9438763up_ends
upheap13105213uphea_p
upheave1544023upheave
upheaves1643913upheaves
upkeeps1532193upkeeps
upleap10106843uplea_p
upleapt11116863upleapt
uplifts12424773uplifts
uploads10266503uploads
uppers102912293uppe_rs
uprate83916543up_rate
uprates93814863up_rates
upreach1444693upreach
uprear8168793uprea_r
uproars986453uproars
uproots937143uproots
upsends10265293upsends
upsent83314063upsent_
upset73222593upse_t_
upshots1235193upshots
upsoars985413upsoars
upstarts10165273upstarts
upstate91610493upstate
upstates10189643upstates
uptear896783uptea_r
uptilts934733uptilts
upwafts1541943upwafts
upwells12244303upwells
urbias839093urbia_s
ureas55826013u_rea_s
urtexts1433143urtexts
usneas638333usnea_s
uveas84912283u_vea_s
wheats125013223_wheats
zibets1737743zibe_ts

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.453394461.4
2DLD Change Limit1340271847.65617506.1
3Display Results1841840.0632920.6
 (SQL Overall)1786911848.17221866.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.