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

462 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
empty124776(None) 
amity10416092amity
amply125012912amply
embay123410602embay
emery104814332emery
emit65438422emit_
emits75421472emits
emmy116013242em_my
emote75421192emote
empathy1743482empathy
empery1348682empery
employ1346492employ
emptily1445812emptily
enmity1137482enmity
espy969372esp_y
hempy154912762hemp_y
imply124911842imply
kempt134318462kempt_
meaty107021312meaty
melty104918362melty
mity95528212_mity
tempt95124842tempt_
tempts10439452tempts
ambry123512103ambry
amp77541023amp__
amped104820513amped
ample94720303ample
amps86230343amp_s
ampul91110853ampul
apply125111393apply
apt57352543_apt_
aptly105111813_aptly
arty77531313_arty
aunty85919813aunty
banty106624003banty
batty105422243batty
bawty135614103bawty
beauty115410163beauty
bemata10411693bemata
bitty106119173bitty
booty106125913booty
borty105522833borty
bumpy144715053bump_y
buppy144810073buppy
busty105621013busty
butty104020113butty
campy145116183camp_y
canty105226803canty
catty104520413catty
cecity1398153cecity
city95122623_city
coempt12311033coempt_
coempts1335683coempts
comity13312713comity
comply152810383comply
compt116328223compt_
compts125216653compts
copay126516313copay
copy116229803cop_y
cuppy144710383cuppy
cutty105417223cutty
damply14337893damply
deeply1257013deeply
deity94316773deity
demit84832303demit_
demits94918073demits
demote94817803demote
demy105422853dem__y
depth114311853depth
deputy12426713deputy
dicty115116293dicty
dimity12310473dimity
dimply14339743dimply
dippy135111543dippy
dipt77339323dipt_
dirty95617803dirty
ditty95019293ditty
dopey116020353dopey
dopy106224153dop_y
dorty96220813dorty
dotty94516103dotty
doty86128223_doty
dumpy135414753dump_y
dusty96018323dusty
duty85321453_duty
early85324123early
earth85023053earth
earthy12399943earthy
east46659103east_
easts57530323easts
easy76224493e_asy
eat36989053e_at_
eath75735663e_ath
eats47054873e_ats
ebony104511513ebony
echt95722903echt_
eddy93912093e_ddy
edgy94713523e_dgy
edify12308563edify
edit54934863edit_
edits65819033edits
eely77725213e_ely
eery76129623e_ery
eft66038823e_ft_
efts76519483e_fts
eggy96611853e_ggy
eighty133711603eighty
elate55335883elate
elegy939303elegy
elite56230183elite
elmy95616793e_lmy
elute54822573elute
em49445153em___
email74715103email
embar94011603embar
embays131408333embays
embed105014303embed
ember95516803ember
embody1435033embody
emboly1336723emboly
embow1297563embow
embryo1363963embryo
emcee9315943emcee
eme55837183em__e
emeer74815363emeer
emend86214893emend
emes65434663em_es
emetic10614453emetic
emetin8613463emetin
emeu66723433em_eu
emeus76913333emeus
emeute838533emeute
emic86422753em_ic
emir65918703em_ir
emirs76116163emirs
emmer94314463emmer
emmet94221383emmet
emmets10349153emmets
emmys12446023emmys
emoted94614923emoted
emoter85415193emoter
emotes84620283emotes
empale102611263empale
empire1039323empire
employe1476363employe
employs1455523employs
emptied1297393emptied
emptier1187603emptier
empties11712243empties
emptins1179403emptins
emptying1634243emptying
ems56435493em__s
emu55929983em__u
emus66821683em_us
emyd1047073em_yd
emyde1136383emyde
emyds1144923emyds
enate54428143enate
enemy1059993enemy
enjoy1545963enjoy
ensky1235093ensky
entity9312053entity
entry82414263entry
envoy1156713envoy
envy10411253e_nvy
epee64628503e_pee
epha9310053e_pha
epic86921303e_pic
epos66723733e_pos
epoxy17465773epoxy
equity1838103equity
erst47436433erst_
erupt74220063erupt_
erupts8348903erupts
essay867623essay
et26964193e__t_
eta35834193e__ta
eth66630983e__th
every115215453every
evite85317683evite
exempt1737453exempt_
exempts1844023exempts
exit114428673exit_
exits125515913exits
expat14313813expat
expats1537683expats
expel1448233expel
expiry1834653expiry
expo1349183exp_o
expos1449203expos
eyry106315883e_yry
fatty115117413fatty
fealty122910223fealty
feisty12449293feisty
ferity122813343ferity
fifty145211423fifty
fluty114415643fluty
footy115820533footy
forty114824273forty
fusty115016513fusty
gappy136212033gappy
gapy106320913gap_y
gemmy135211053gem_my
gemot84024233gemot_
gemote94613023gemote
gemots93712153gemots
gimpy135212233gimp_y
gipsy11579543gipsy
gouty95217363gouty
guppy135211273guppy
gusty95119573gusty
gutty94516993gutty
gypsy14636993gypsy
haply135915063haply
happy155813533happy
hasty115718763hasty
heapy135914983heap_y
hearty126313633hearty
hefty146112133hefty
hemp115725623hemp__
hempen1338963hempen
hempie132410563hempie
hemps126917333hemp_s
hiply134113613hiply
hippy155112793hippy
hooty115022433hooty
hoppy154912353hoppy
humpy155115673hump_y
immy114611833im_my
imp76626973imp__
imped105117983imped
impel95711773impel
impi85415793imp_i
impiety1445093impiety
impis96213853impis
imps86221123imp_s
impute1038043impute
janty156816963janty
jemmy19498553jem_my
jetty156212583jetty
jimply20397483jimply
jimpy195210823jimp_y
jolty155713033jolty
jotty155012603jotty
jumpy195712813jump_y
jutty154914643jutty
kelpy145110683kelp_y
kemp126418763kemp__
kemps135012523kemp_s
kept106232943kept_
kilty125213893kilty
kitty124614563kitty
laity85318903laity
lealty92910603lealty
leapt75027473leapt_
lefty115613563lefty
lemony11419553lemony
lenity9612713lenity
lept66440883lept_
lepta75714393lepta
levity1277903levity
limply133810033limply
limpsy13516843limpsy
linty87126563linty
lippy124511903lippy
lofty115813303lofty
loppy125911663loppy
lumpy126615913lump_y
lusty85417573lusty
malty106721703malty
many95731843_many
mat58083933_mat_
mate65154213_mate
matey107022663_matey
math95437443_math
mats65460283_mats
matt65752653_matt
may88757623_m_ay
mazy186419693_mazy
mealy104422183mealy
meany104620473meany
meat66359603meat_
meats75034053meats
meet65350553meet_
meetly1138673meetly
meets74224613meets
meiny104015413meiny
melt65752893melt_
melts74930103melts
memory1338803memory
menta74424423menta
mercy125916183mercy
merry104721483merry
meshy135612783meshy
messy104913833messy
met56072433_met_
meta65932413_meta
mete64438133_mete
meth95827843_meth
milty104720073milty
minty106323903minty
miry96326753_miry
misty106120453misty
mite66249413_mite
mitt66145493_mitt
moly96031913_moly
mony96830003_mony
mopey124821823mopey
mopy115721973_mopy
mot57279423_mot_
mote67048083_mote
motey105922953_motey
moth96731333_moth
mothy136214553_mothy
mots66853163_mots
mott66648443_mott
musty105620953musty
mut58357183_mut_
mute65136873_mute
muts64839983_muts
mutt65739403_mutt
my78125653_m__y
myth126715433_myth
mythy16568673_mythy
nappy126312333nappy
nasty85717283nasty
natty85719143natty
netty85816763netty
nifty115211633nifty
nippy124911113nippy
nitty85418313nitty
nonempty1543503nonempty
nutty84816873nutty
omit65337373omit_
omits75018263omits
opt57545543_opt_
opts68124743_opts
panty105929303panty
pappy114713803pappy
party106630613party
pasty105725053pasty
patty104723613patty
paty95234563_paty
pay88461183__pay
peaty105725693peaty
peppy114310363peppy
pesty106421713pesty
petty105320293petty
piety105817303piety
pimply15329213pimply
pipy115421513pip_y
pity96031933_pity
platy105021663platy
ply86323553__ply
poppy114813193poppy
popsy125713403popsy
potty105621003potty
pouty107018813pouty
pry85728053__pry
punty106021613punty
puppy114912413puppy
purty105019403purty
putty104721403putty
rapt67245313rapt_
raptly11338913raptly
ratty84819593ratty
realty92713693realty
remate84428683remate
remedy1237863remedy
remet74843723remet_
remit75737223remit_
remits85622943remits
remote84222603remote
repay104818453repay
reply104015853reply
rooty86423023rooty
ropey106021873ropey
ropy96323413rop_y
rumply13348573rumply
runty86119043runty
rusty85221053rusty
rutty85617803rutty
salty85524383salty
sappy125413473sappy
seepy104717973seep_y
semple103212753semple
sempre102710093sempre
sepoy10314303sepoy
sept65844363sept_
septa75518083septa
septs75420603septs
silty84721633silty
simply133010523simply
sixty154912733sixty
slaty86523153slaty
smarty115013793smarty
smit65138413smit_
smite75224873smite
smith107818053smith
smithy14508273smithy
smoky14388683smoky
smote75820273smote
smut66629783smut_
smuts75415713smuts
smutty11266323smutty
softy115414483softy
sooty84924833sooty
sophy136611763sophy
soppy125113523soppy
spay96631663_spay
spry96819123_spry
spy86023743_sp_y
sty66227313__sty
suety85318493suety
tarty86328183tarty
tasty84820313tasty
tatty84720183tatty
teapoy1138113teapoy
temp85323333temp__
temped113912893temped
tempeh13357463tempeh
temper103914093temper
tempi94912203temp_i
temple102811333temple
tempo95214973temp_o
tempos103812293tempos
temps95417133temp_s
tempted12317283tempted
tempter11358213tempter
tenty86121603tenty
tepoy10312163tepoy
testy85419063testy
tippy125411793tippy
tipsy106010503tipsy
titty85316653titty
tufty114810413tufty
tutty85217023tutty
typey135511883typey
typy126013043typ_y
ump76130443ump__
umped104717273umped
umps85721943ump_s
unity84918493unity
upby1139063_upby
uppity1335103uppity
vampy15539403vamp_y
vasty116215923vasty
verity123714853verity
warty119323823warty
weepy134212593weep_y
wept95635053wept_
whity145513473whity
wifty144212093wifty
wimpy155911923wimp_y
witty114717013witty
yeasty12438693yeasty
yuppy15487913yuppy
zappy21548943zappy
zesty176512163zesty
zippy21518743zippy
zloty17399793zloty
zooty175415353zooty

Search took 5 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 Filter178691836670.1101624463.6
2DLD Change Limit836674624.34319264.8
3Display Results4624620.1732670.5
 (SQL Overall)1786914624.62638627.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.