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

274 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
uptears910645(None) 
upbears1195421upbears
uprears9107491uprears
uptear896781uptear_
appears11308952appears
pears75138612_p_ears
retears72814922retears
spears84019472sp_ears
tears55436462__tears
unbears998042unbears
upbear1096492upbear_
upbeats1195732upbeats
upheaps1494232upheaps
upleaps1185232upleaps
uppers102912292uppe_rs
uprear8168792uprear_
uproars986452uproars
upsoars985412upsoars
utters63817122utte_rs
afters94717073afte_rs
altars64518153alt_ars
alters64924223alte_rs
anears63717183_anears
antbears1044963antbears
antiars7314623antiars
apers76629133ap_e_rs
apneas83211383apnea_s
appeals11378673appeals
appear10379343appear_
apter76120203apte_r_
apteral9311523apteral
arrears738843arrears
asters65631603aste_rs
attars64515313_attars
auteurs7137513auteurs
bears75739043__bears
biters83925243bite_rs
blears85116453_blears
bugbears1333693bugbears
bunters94717123bunte_rs
busters94724133buste_rs
butters94521723butte_rs
caters85336503cate_rs
citers85022983cite_rs
clears84116563_clears
copters113621283copte_rs
cottars94412243cottars
cudbears1343483cudbears
cuppers133712213cuppe_rs
cutters94218963cutte_rs
daters74827373date_rs
dears65736883__dears
deters74724683dete_rs
dogears937513dogears
doters74423913dote_rs
drears74614253_drears
dupers94615603dup_e_rs
dusters84918363duste_rs
ears46356593___ears
eaters65535953eate_rs
endears83710053endears
enters64425643ente_rs
esters64627733este_rs
eupneas935233eupnea_s
fears84829393__fears
gateaus866333gateaus
gaters74728643gate_rs
gears64628693__gears
guitars8116863guit_ars
gutters83715513gutte_rs
haters94930403hate_rs
hears86737373__hears
hunters103915733hunte_rs
hurters103413653hurte_rs
inters64328053inte_rs
justers143815733juste_rs
kiters105218593kite_rs
lears55938733__lears
liters65429883lite_rs
lupanars1042303lupanars
lusters73921443luste_rs
maters85032393mate_rs
meteors94610013meteors
meters85625833mete_rs
miters84328783mite_rs
musters94522513muste_rs
mutters94117143mutte_rs
nears55529423__nears
niters64624213nite_rs
noters64021003note_rs
nuptials1044303nuptials
nutters74215433nutte_rs
oaters65029793oate_rs
operas8312453op_eras
ottars64112223_ottars
otters64021513otte_rs
ousters74122793ouste_rs
outearn7310683outearn
outearns838403outearns
outeats72215703outeats
outers64230173oute_rs
outhears11810393outhears
outwars10912793outwars
outwears1197263outwears
oxters134813273oxte_rs
paeans85118263_paeans
pars67560793_p__ars
paters84935833pate_rs
peags86122843_p_eags
peaks114825623_p_eaks
peals75235493_p_eals
peans75437643_p_eans
pear69745233_p_ear_
pearl75324463_p_earl
pearls84715393_p_earls
peart76440753_p_eart
peas65755063_p_ea_s
peats76140193_p_eats
peers75130273_p_eers
petals84719813_petals
petard95013803_petard
petards104311153_petards
peters86624593_peters
piers75926333_pie_rs
pleads94613953_pleads
pleas75627033_plea_s
pleats85218593_pleats
polars84419353_polars
prearm104512353_prearm
prearms11369173_prearms
pulers83820283pule_rs
pulsars9358913pulsars
punters93617043punte_rs
putters94219193putters
quoters16369273quote_rs
raters63936583rate_rs
rears54739653__rears
redears82814453redears
regears83012463regears
rehears103312773rehears
reteams9339563reteams
retear63115483retear_
rewears102911043rewears
sears54744913__sears
shears93820903_shears
shmears1277073shmears
sitars65417593sit_ars
smears84714433_smears
spars75431543sp__ars
speaks125114583sp_eaks
speans85417143sp_eans
spear75821063sp_ear_
speers85019953sp_eers
speirs85013233sp_eirs
spiers84421743spie_rs
spreads1039763spreads
stars55836573_st_ars
steads74116223_steads
steaks104415853_steaks
steals64020063_steals
steams84916903_steams
steers63820983_steers
suiters73618883suite_rs
sumpters1238023sumpte_rs
supers84622403sup_e_rs
suppers113314703suppe_rs
swears94114073_swears
tars46763953__t_ars
tatars64619793tat_ars
taters64932203tate_rs
teaks94222903__teaks
teals56234133__teals
teams75726513__teams
tear45242883__tear_
teary85124053__teary
teas45851493__tea_s
teats55636813__teats
titers64526413tite_rs
toters65026363tote_rs
tsars56717113__tsars
tuateras836203tuateras
tufters10298353tufte_rs
tutelars844993tutelars
tzars144914273__tzars
udders83911293udde_rs
ulcers839383ulce_rs
ulsters72711983ulste_rs
ultras6310193ultra_s
umbers104215213umbe_rs
unbars82113033u_nbars
unbear889163unbear_
unheard1136943unheard
uniters73814173unite_rs
unleads8228623unleads
unlearn735953unlearn
unlearns844453unlearns
unseals73212583unseals
unseams9338913unseams
unseats73012853unseats
unswears1144023unswears
unteach1246143unteach
untreads936223untreads
unweary1335843unweary
upas68322383up__a_s
upbearer1243583upbearer
upbearers1343033upbearers
upbeat10911513upbea_t
updart9310743up_dart
updarts1034203up_darts
updaters11255183update_rs
upends9438763up_ends
upheap13105213uphea_p
upheave1544023upheave
upheavers1742593upheavers
upheaves1643913upheaves
uphoard1344573uphoard
uphoards1443763uphoards
upkeeps1532193upkeeps
upleap10106843uplea_p
upleapt11116863upleapt
uploads10266503uploads
upper93714263uppe_r_
upreach1444693upreach
upreared1137083upreared
uproar8106933uproar_
upsends10265293upsends
upsets8409683upse_ts
upsoar8105683upsoar_
upstairs1043643upstairs
upstare9158683upstare
upstares10178583upstares
upstart9159753upstart
upstarts10165273upstarts
upsteps1133743upste_ps
upstirs935293upstirs
uptake1236963upt_ake
uptakes1336593uptakes
uptalk1234653upt_alk
uptalks1333723uptalks
uptearing1236103uptearing
uptempo1342413uptempo
uptempos1441923uptempos
upticks1535153upticks
uptilts934733uptilts
uptimes1177553uptimes
uptore8279453upt_ore
uptorn8268093upt_orn
uptoss836093upt_oss
uptowns12194343uptowns
uptrends1142833uptrends
upturn8286243upt_urn
upturns9264973upturns
upward12147163up_ward
upwards13135963up_wards
upwells12244303upwells
ureas55826013u_rea_s
ureters7311823ureters
urgers73313623urge_rs
urtexts1433143urtexts
users55817573u_se_rs
ushers94415533ushe_rs
usneas638333usnea_s
utas45924953u_t_a_s
uteri51012983u_te_ri
uterus639203u_terus
utes45930883u_te__s
utter54218763utte_r_
utterers8218653utterers
uveas84912283u_vea_s
uvulars1044413uvulars
voters95017443vote_rs
waters95030633wate_rs
wears86030303__wears
years84527673__years

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.423422437.4
2DLD Change Limit1340272746.43620824.6
3Display Results2742740.0932946.2
 (SQL Overall)1786912746.95225703.5
 
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.