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

319 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
empties1171224(None) 
emptied1297391emptied
emptier1187601emptier
emptiers1275191emptiers
emptiest1278101emptiest
emptins1179401emptins
amities9317382amities
emeries91620022emeries
emetics11610722emetics
emetines10611052emetines
emetins9812642emetins
emotes84620282emot_es
empales112411432empales
empathies16115402empathies
emperies12314562emperies
empires1139852empires
emprise11310722emprise
emprises12311002emprises
emprizes2138132emprizes
emptily1445812emptily
emptiness1335372emptiness
emptings1364822emptings
enmities10611352enmities
espies83716802esp_ies
implies11312122implies
ambries111614553ambries
amies76837693am__ies
amperes11313983amperes
ampules1189433ampules
amputees1245103amputees
applies11311213applies
aunties73920073aunties
banties94324763banties
baptise1139553baptise
baptises1238923baptises
baptizes2136843baptizes
bawties124214313bawties
beasties102514653beasties
beauties10229523beauties
booties94124613booties
buppies133011063buppies
butties93217953butties
captives1538623captives
catties94023053catties
cecities12312043cecities
cities84524853_cities
comities12317793comities
complies14314523complies
cooties93725733cooties
copies104130303cop_ies
cuties84927363_cuties
cutties93118843cutties
dauties83315763dauties
dawties113312703dawties
deities82621923deities
demies94825803dem__ies
demotes104717673demot_es
demotics1338753demotics
deputies1157533deputies
despites11410313despites
dimities11314003dimities
dirties83119383dirties
ditties83116983ditties
duties74921903_duties
easies64126633e_asies
ebonies9312883ebonies
eddies83313163e_ddies
edifies113012283edifies
eighties12710803eighties
elates65032363elat_es
elatives1139783elatives
elegies81312903elegies
elites66027123elit_es
elutes64020313elut_es
emails84412343em_ails
embodies1337003embodies
embolies1239153embolies
embrues1136473embrues
emcees1037813em_cees
emerges101310883emerges
emes65434663em___es
emeses86114963em_eses
emesis84712623emesi_s
emetic10614453emeti_c
emetin8613463emeti_n
emetine9712943emetine
emeutes938013emeutes
emigres1037673emigres
emirs76116163em__irs
emits75421473em__its
emitted103010853emitted
emitter93211083emitter
emitters10349643emitters
emodins1039433emodins
emote75421193emot_e_
emoted94614923emot_ed
emoter85415193emot_er
emoters94712873emoters
emoting10313563emoting
emotion9711303emotion
emotions10610283emotions
emotive1239193emotive
empale102611263empale_
empaled12288953empaled
empaler11288353empaler
empalers12226743empalers
empanel1145963empanel
empanels1244823empanels
empathise1684183empathise
empathises17104063empathises
empathizes2673443empathizes
emphases1568353emphases
empire1039323emp_ire
empirics1444003empirics
emplaces1438413emplaces
emplanes1239503emplanes
employes1555943employes
employs1455523employs
empower14217033empower
empowers15276843empowers
empress1138163empress
emprize2038843emprize
empty1247763empt__y
emptying1634243emptying
emydes1236173em_ydes
enates64026433enat_es
endites83717063endites
enemies9313693enemies
enskies1138573enskies
entices91616333e_ntices
entires71517783e_ntires
entities8617413entities
entries71523163entries
envies9314053e_nvies
epees75219833e_p_ees
epics95014283e_p_ics
epodes94315563e_podes
eposes84418783e_poses
epoxies1637753epoxies
equites162212493equites
equities17310773equities
erotics91914153erotics
erotizes17311213erotizes
eruptives1443853eruptives
espied9359773esp_ied
esprits938393esprits
evites94916473evit_es
excites16310633excites
exotics16229193exotics
expires1638683expires
expiries1747753expiries
exposes1639963exposes
eyries93816813e_yries
fatties103018203fatties
fealties1139993fealties
ferities111416713ferities
fifties132111083fifties
footies103721543footies
forties104323863forties
gemotes103712143gemot_es
gipsies1039903gipsies
guppies123310523guppies
gypsies1335953gypsies
hearties11315413hearties
hematics151712193hematics
hematines141312203hematines
hematins131714683hematins
hematites141510793hematites
hempie132410563hemp_ie_
hempier14319003hemp_ier
hempiest1539023hemp_iest
hippies142813743hippies
hogties112813993hogties
hotties103016963hotties
immies102412443im_mies
impairs1135823impairs
impales113311763impales
impatiens1345733impatiens
impedes124310093impedes
imphees1436693imphees
impieties1345963impieties
impis96213853imp_i_s
implied1238623implied
impones112712253impones
imposes113213683imposes
imputes1138083imputes
jemmies18318333jem_mies
jetties143613123jetties
jutties143814003jutties
kelpies13289903kelp_ies
kewpies16246923kewp_ies
kilties113014143kilties
kitties113213623kitties
koppies153210013koppies
laities7320343laities
lealties8310793lealties
lefties10312073lefties
lenities8315943lenities
leptins92412693leptins
levities11310713levities
mamies104626243_mamies
mates75251363_mat_es
matier84321523_matier
matiest92522453_matiest
matins84527783_matins
matres84522233_matres
mattes85624533_mattes
mavies114923193_mavies
mealies92821933mealies
meanies93620743meanies
meatier93214613meatier
meatiest102816793meatiest
meinies92516073meinies
memetics1447803memetics
memories121214353memories
mentees93214503mentees
mercies113817563mercies
mestees94617753mestees
metes74736213_met_es
metier83517693_metier
metiers93312843_metiers
metis75025903_meti_s
metres85121563_metres
mettles94115023mettles
mites75141803_mit_es
mitier83620673_mitier
mitiest93520053_mitiest
mitis75425993_miti_s
mitises9315543_mitises
mitres83922073_mitres
molies84429513_molies
monies83233163_monies
motes75944003_mot_es
motifs1139673_motifs
motiles93317433_motiles
motives123611893_motives
mottes85523693_mottes
movies115118453_movies
moxies154317403_moxies
mutes75033783_mut_es
mutines93117823_mutines
nappies114613393nappies
nasties73520493nasties
neckties1445903neckties
nifties102612503nifties
optics102810183_optics
optimes1148473_optimes
panties94230933panties
pappies103214823pappies
parties93230863parties
pasties94529813pasties
patties93425143patties
pemphixes2543003pemphixes
peptics132610243peptics
peptides132610263peptides
peptids12239323peptids
peptizes21269853peptizes
pies66949603__p_ies
pieties9419223pieties
pities83828083_pities
platies93722543platies
plies74526513__plies
poppies102816193poppies
popsies112816463popsies
posties93128813posties
potpies113116173potpies
potties93723543potties
pries74339533__pries
punties94520783punties
puppies103212613puppies
putties94420023putties
realties8514853realties
remates93827113remat_es
remedies11310553remedies
remotes94521613remot_es
replies94521043replies
reptiles103913063reptiles
respites10513243respites
reties65436193_reties
riptides1136413riptides
salties73725773salties
septics112810433septics
septimes1238303septimes
sixties14310973sixties
smarties10312873smarties
smites83921923smit_es
smithies1337913smithies
softies103414613softies
sophies12314613sophies
sopites93817173sopites
sorties74126403sorties
spies76037623_sp_ies
spites84127333_spites
sties55132983__sties
tatties74120343tatties
temples112610893temp_les
tempted12317283tempt_ed
tempter11358213tempt_er
tempters12257293tempters
tempting1357343tempting
temptress1343133temptress
tempts10439453tempt__s
ties45248313___ties
tiptoes939173tiptoes
titties73617363titties
tutties73216473tutties
umpires1137813umpires
umpteen1143843umpteen
unities72520153unities
unties64326923_unties
uptimes1177553_uptimes
verities111418043verities
weepies122811743weep_ies
whities133113253whities
yippies14279293yippies
yuppies14339263yuppies
zaptieh2144563zaptieh
zaptiehs2241863zaptiehs
zloties1639913zloties

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 Limit1340273196.00022337.8
3Display Results3193190.1102900.0
 (SQL Overall)1786913196.51627423.4
 
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.