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

273 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
premixes19311008(None) 
prefixes20389231prefixes
premies113823061premi_es
premises123018271premises
premixed20338001premixed
remixes164313871_remixes
bemixes18338652_bemixes
eremites10312602eremites
panmixes1934912panmixes
phenixes2035642phenixes
precipes143212212precipes
precises123218332precises
preemies12512192preemi_es
prefiles133113442prefiles
prefires134313282prefires
prefixed21357692prefixed
prelives13310382prelives
premie103617992premi_e_
premier113515632premi_er
premieres13288232premieres
premiers122911652premiers
premise113818552premise_
premised133013192premised
premiss113513812premi_ss
premisses13288762premisses
premiums1437532premiums
premix173710332premix__
premixt183510662premix_t
presides11414912presides
previses133814282previses
prewires133811012prewires
prexes154915942pre__xes
prexies163415002prexi_es
primines123013702primines
promines123018802promines
promises122916762promises
refixes174813172_refixes
remiges103015472_remiges
remises93423482_remises
remixed173510742_remixed
admixes1765963_admixes
apomixes1934853apomixes
arenites8917103arenites
armies85123693ar_mi_es
bemires113212833_bemires
bemixed19337053_bemixed
brewises1337213brewises
bromides13219363bromides
bromines122514253bromines
bromizes21258333bromizes
cervixes2054603cervixes
chemises153211983chemises
commixes2177353commixes
cremates124216003cremates
cremes104517993crem__es
creminis12208253creminis
crevices1536713crevices
demies94825803_demi_es
demises103719563_demises
dermises112512023dermises
enemies9313693enemi_es
eremite9312833eremite_
ermines9416673er_mines
fremitus1344023fremitus
grecizes2035683grecizes
greiges937733gre_iges
gremials1136133gremials
gremmies1355993gremmies
helixes1739133_helixes
immixes1835073_immixes
itemises1087693itemises
itemizes19106023itemizes
kermises14248313kermises
mixes147224403___mixes
oreides8312023ore_ides
overmixes2137323overmixes
panmixis1943303panmixis
peeries93623023peeri_es
peises84125043p_e_ises
pelites93821993p_elites
pemphixes2542993p_emphixes
penises9318193p_enises
perlites10316353perlites
permits11314003permi_ts
permutes1238713permutes
perries93226603perri_es
petites93820203p_etites
phoenixes2143393phoenixes
pieties9419223pieti_es
pigmies122610993pigmi_es
pismires1235883pismires
pixes144323173p___ixes
plexes155313533ple__xes
poesies93217403poesi_es
poetises10313953poetises
poetizes19310253poetizes
polemizes2248143polemizes
pommies133712843pommi_es
praecipes1544853praecipes
praises94121103pr_aises
pralines102217723pralines
praxes156215183pr__axes
praxises1739063praxises
preaches153214893preaches
preambles1545333preambles
prebakes1639013prebakes
prebids12399883prebi_ds
prebills1237293prebills
prebinds13357733prebinds
precedes13310703precedes
precious12310593precious
precipe133012123precipe_
precis103416703preci__s
precise113518173precise_
precised133213413precised
preciser123411663preciser
precisest13259003precisest
precited133013813precited
precodes13711573precodes
precures12312903precures
predates11615813predates
predicts1339613predicts
predigest1357633predigest
predive13511083predive_
predries112714383predries
preemie11310563preemi_e_
prees75937173pre___es
prefaces15311063prefaces
prefades1439533prefades
prefile123413183prefile_
prefiled143310573prefiled
prefire124012813prefire_
prefired144310753prefired
prefix18356853prefix__
prefixal2044543prefixal
pregames1339003pregames
preguides1344863preguides
prelates10418573prelates
prelife1279943prelife_
prelims1139823preli_ms
preludes1137833preludes
premade12311443premade_
premed114617753prem__ed
premeds12389583prem_eds
premeet11615153prem_eet
premen105017803prem__en
premiere12249233premiere
premiered14237083premiered
premium13310363premi_um
premixing2157803premixing
premolds1345843premolds
premorse1237553premorse
premune1138933premune_
prenames12311643prenames
prentices131111903prentices
prepares122014163prepares
prepaves15189193prepaves
preppies1149683preppies
preprices1569263preprices
prepubes1436053prepubes
prepuces1438583prepuces
prerinse1038633prerinse
prerinses1138813prerinses
presages11312203presages
presales10315263presales
preside10715613preside_
presided12410553presided
presider11410423presider
presiders1248213presiders
presifts1366593presifts
preslices1338213preslices
presses93523153pre_sses
prestiges12310593prestiges
presumes1239843presumes
pretapes122811533pretapes
pretexts1735603pretexts
pretties10615133pretties
pretypes15337263pretypes
preunites1138933preunites
preview1536473previ_ew
previews1634513previews
previous1337823previous
previse123713793previse_
prevised143611073prevised
prevues1239263pre_vues
prewire124311133prewire_
prewired14358473prewired
prezes173614693pre__zes
prices104524543pr__ices
prides94324183pr__ides
pries74339533pr__i_es
primages13159273primages
primates121515933primates
primes104225263pr__imes
primine113214823primine_
primings13338143primings
primuses1237083primuses
prises84133173pr__ises
privies122414263privi_es
prizes173819813pr__izes
profiles133211233profiles
prolines102619693prolines
promine112819443promine_
promise113415843promise_
promised133010873promised
promisee122711333promisee
promisees13246863promisees
promiser122510673promiser
promisers13268203promisers
promotes12314123promotes
propines122618933propines
provides1439883provides
proxies163014933proxi_es
pumices1338273p_umices
pyemias1436803pyemi_as
pygmies15205673pygmi_es
pyrexes19305833pyre__xes
radixes15259343_radixes
ramies84630463_rami_es
recipes113314463_recipes
recites93524583_recites
redoxes15310883_redoxes
refiles104122423_refiles
refines105426343_refines
refires104820313_refires
refixed183611153_refixed
regimes104514743_regimes
regives115014213_regives
rehires105016113_rehires
reives95723043_re_ives
relaxes143215323_relaxes
relies65036423_reli_es
relines75331323_relines
relives104619443_relives
remakes134116173_remakes
remates93827113_remates
reminds104614793_reminds
remints95117293_remints
remise84221953_remise_
remised103516843_remised
remiss84216353_remi_ss
remits85622943_remi_ts
remix145916553_remix__
remixt155014853_remix_t
remotes94521613_remotes
removes124514713_removes
repines94927383_repines
rerises73525883_rerises
resides84523283_resides
resiles74026543_resiles
resites74027793_resites
resizes164216843_resizes
retaxes143615093_retaxes
reties65436193_reti_es
retiles74426993_retiles
retimes95020173_retimes
retines75134673_retines
retires74726213_retires
reviles104421353_reviles
revises104220533_revises
revives134715543_revives
rewaxes173911333_rewaxes
rewires104717113_rewires
rexes124526953_re__xes
rexines144719153_rexines
semises93916553_semises
spermines13310543spermines
termites10313693termites
trembles1237353trembles
unmixes16197753_unmixes
ureides8311103ure_ides
uremias9249503uremi_as
vernixes1836053vernixes

Search took 8 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622737.59319249.6
3Display Results2732730.0932935.5
 (SQL Overall)1786912737.84222786.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.