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

169 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
emptied129739(None) 
emptier1187601emptier
empties11712241empties
emitted103010852emitted
emoted94614922emot_ed
empaled12288942empaled
emptiers1275192emptiers
emptiest1278102emptiest
emptily1445812emptily
emptins1179402emptins
espied9359772esp_ied
implied1238622implied
tempted12317282tempt_ed
amities9317383amities
amped104820513amp__ed
applied1247483applied
baptised1335253baptised
baptized2245473baptized
citied94014143_citied
coempted1535333coempt_ed
complied1539673complied
compted143813523compt_ed
copied114618563cop_ied
demitted12288773demitted
demoted114313543demot_ed
despited1248323despited
dirtied93210853dirtied
earthed1139923earthed
eddied9248323e_ddied
edified12339713edified
edited83913673edit_ed
elated74725823elat_ed
eluted74915263elut_ed
emailed10359213emailed
embayed1535443embayed
embed105014303em__bed
embodied1445293embodied
embowed15236903embowed
embrued1235293embrued
emceed1136283em_ceed
emended11329603emended
emerged11158213emerged
emeries91620023emeries
emersed10138513emersed
emetic10614453emeti_c
emetics11610723emetics
emetin8613463emeti_n
emetine9712943emetine
emetines10611053emetines
emetins9812643emetins
emitter93211083emitter
emote75421193emot_e_
emoter85415193emot_er
emotes84620283emot_es
emoting10313563emoting
emotion9711303emotion
emotive1239193emotive
empale102611263empale_
empaler11288353empaler
empales112411433empales
empanel1145963empanel
empathies16115393empathies
empathised18112793empathised
empathized27113103empathized
emperies12314563emperies
empire1039323emp_ire
empires1139853empires
emplaced1536043emplaced
emplaned1337153emplaned
employed1654943employed
empower14217033empower
emprise11310723emprise
emprises12311003emprises
emprize2038843emprize
emprizes2138133emprizes
emptiness1335373emptiness
emptings1364813emptings
empty1247763empt__y
emptying1634243emptying
endited93512913endited
enmities10611353enmities
enskied1234653enskied
enticed101411193e_nticed
envied1038833e_nvied
epoxied1734813epoxied
erotized1838543erotized
erupted10207163erupt_ed
espies83716803esp_ies
evited104013143evit_ed
exapted1736073exapt_ed
excited1737853excited
exempted2044143exempt_ed
exited144712523exit_ed
expired1736403expired
exposed1737443exposed
gipsied1135873gipsied
gypsied1443263gypsied
hempie132410563hemp_ie_
hempier14319003hemp_ier
hempseed1643603hempseed
hempweed1942793hempweed
hogtied12226653hogtied
impaired1335143impaired
impaled12288503impaled
imped105117983imp__ed
impeded13418183impeded
impled113812513imp_led
implies11312123implies
imponed12279453imponed
imposed123110293imposed
imputed1236533imputed
jemmied19294483jem_mied
jettied15366973jettied
juttied15417863juttied
mated85537783_mat_ed
matier84321523_matier
matted94521413_matted
meated94222403meat_ed
meatier93214613meatier
melted94219063melt_ed
merited10313853merited
meted85424433_met_ed
metier83517693_metier
metred95315143_metred
mettled103510543mettled
mitier83620673_mitier
mitred94414343_mitred
monied94319463_monied
motived13357763_motived
muted85023383_mut_ed
mutined103311353_mutined
omitted10347893omitted
opted84914273_opt_ed
partied103516553partied
peptid112712373pepti_d
peptide122910683peptide
peptized22237503peptized
pied75035363__p_ied
pitied94017253_pitied
plied85118593__plied
poppied11388983poppied
pried84426863__pried
puttied103811163puttied
remated103522473remat_ed
remedied1237953remedied
remitted113312073remitted
replied103914443replied
respited11410813respited
retied75924983_retied
riptide1036883riptide
smutted1037463smutted
sopited104211053sopited
sortied83314093sortied
spied85427713_sp_ied
spited94820443_spited
stied65723033__stied
temped113912893temp__ed
tempered13248213tempered
templed12278553temp_led
tempter11358213tempt_er
tempting1357343tempting
tied55535213___tied
tiptoed1036143tiptoed
umped104717273ump__ed
umpired1235783umpired
umpteen1143843umpteen
unpitied1138783unpitied
untied73720813_untied
zaptieh2144563zaptieh

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.1531167915.0
2DLD Change Limit1340271696.42320866.7
3Display Results1691690.0632682.5
 (SQL Overall)1786911696.63926915.3
 
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.