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

215 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
premixed2033801(None) 
prefixed21357701prefixed
premised133013191premised
premixes193110081premixes
remixed173510741_remixed
bemixed19337052_bemixed
precised133213412precised
precited133013812precited
prefiled143310572prefiled
prefired144310752prefired
prefixes20389232prefixes
premed114617762prem__ed
premie103617992premi_e_
premier113515632premi_er
premiered14237092premiered
premies113823062premi_es
premise113818552premise_
premises123018272premises
premix173710332premix__
premixt183510662premix_t
presided12410552presided
prevised143611072prevised
prewired14358472prewired
promised133010872promised
refixed183611152_refixed
remised103516842_remised
remixes164313872_remixes
admixed1833733_admixed
bemired123410633_bemired
bemixes18338653_bemixes
bromized22215903bromized
commixed2264743commixed
credited1238253credited
cremated133412963cremated
creviced1634453creviced
demised113613683_demised
eremite9312833eremite_
eremites10312603eremites
ermined10410603er_mined
grecized2134433grecized
immixed1933573_immixed
itemised11105163itemised
itemized20105343itemized
mixed155717253___mixed
overmixed2236063overmixed
panmixes1934913panmixes
peined94918843p_e_ined
peised94817683p_e_ised
periled10316323p_eriled
permed115217353perm__ed
permitted1446653permitted
permuted1336713permuted
phenixes2035643phenixes
plumiped1533313plumiped
poetised1138523poetised
poetized2037983poetized
polemized2346503polemized
praised104214813pr_aised
preached163412063preached
preacted132710943preacted
preaged11612333pre_aged
preambled1643893preambled
prearmed1397993prearmed
prebaked1737173prebaked
prebid113512843prebi__d
prebilled1445063prebilled
prebind123810643prebi_nd
preboiled1455783preboiled
preceded1438293preceded
precipe133012123precipe_
precipes143212213precipes
precise113518173precise_
preciser123411663preciser
precises123218333precises
precoded1438863precoded
precured1339993precured
predated12513273predated
predicted1538913predicted
predive13511083predive_
predried12309573predried
preed85128123pre___ed
preedited1337633preedited
preemie11310563preemi_e_
preemies12512193preemi_es
preempted1644683preempted
preened103214993pre_ened
prefaced1638423prefaced
prefaded1537823prefaded
prefile123413183prefile_
prefiles133113443prefiles
prefilled1535513prefilled
prefire124012813prefire_
prefires134313283prefires
prefix18356853prefix__
prefixal2044543prefixal
preguided1443923preguided
prelife1279943prelife_
prelimited1545493prelimited
prelives13310383prelives
preluded1236473preluded
premade12311443premade_
premeds12389593prem__eds
premeet11615153prem_eet
premen105017803prem__en
premiere12249233premiere
premieres13288233premieres
premiers122911653premiers
premiss113513813premi_ss
premisses13288763premisses
premium13310363premi_um
premiums1437533premiums
premixing2157803premixing
premold1247863prem_old
premolded1544683premolded
premune1138933premune_
prenticed14118063prenticed
preowned1435213preowned
prepared132210873prepared
prepaved16177233prepaved
prepped11329903pre_pped
prepriced1676643prepriced
prerinsed1246323prerinsed
presaged1238803presaged
preside10715613preside_
presider11410423presider
presides11414913presides
presifted1536873presifted
presliced1435983presliced
pressed103317313pre_ssed
presumed1337973presumed
pretaped13339133pretaped
pretexted19135693pretexted
prettied1159253prettied
pretyped16306123pretyped
preunited1246803preunited
prevailed1536043prevailed
preview1536473previ_ew
previewed1843423previewed
previse123713793previse_
previses133814283previses
prevued1337143pre_vued
prewire124311143prewire_
prewires133811013prewires
prexes154915953pre__xes
prexies163415003prexi_es
preyed125313203pre__yed
priced115018883pr__iced
prided103618033pr__ided
pried84426863pr__i_ed
primed115118913pr__imed
primine113214823primine_
primines123013703primines
primmed14388853prim_med
primped14479153prim_ped
prised94322203pr__ised
prized184415393pr__ized
profiled14338523profiled
profited14279973profited
promine112819443promine_
promines123018803promines
promise113415843promise_
promisee122711333promisee
promiser122510673promiser
promises122916763promises
promoed12310083prom_oed
promoted13310543promoted
prompted1536903prompted
propined133111503propined
provided1536843provided
pumiced1435173p_umiced
pyramided1873833pyramided
recited104319103_recited
refiled114318653_refiled
refined114720003_refined
refired115116993_refired
refixes174813173_refixes
rehired115013153_rehired
reined74425523_re_ined
reived104518133_re_ived
relaxed153312533_relaxed
relied74926233_reli_ed
relined85321933_relined
relived115114683_relived
remailed112411403_remailed
remained112412893_remained
remated103522473_remated
remiges103015473_remiges
remind94819793_remi_nd
reminded123411523_reminded
reminted113615083_reminted
remise84221953_remise_
remises93423483_remises
remitted113312073_remitted
remix145916553_remix__
remixt155014853_remix_t
removed134611313_removed
reoiled84316853_reoiled
repined104918773_repined
resided95217703_resided
resiled84621983_resiled
resined84522653_resined
resited85122423_resited
resized174614903_resized
retaxed153512233_retaxed
retied75924983_reti_ed
retiled84420513_retiled
retimed104714653_retimed
retired84620143_retired
reviled114417923_reviled
revised113815483_revised
revived144211653_revived
rewaxed18409343_rewaxed
rewired115413283_rewired
trembled1335253trembled
unmixed17228213_unmixed

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.406440125.6
2DLD Change Limit1461622157.34619896.8
3Display Results2152150.0932311.8
 (SQL Overall)1786912157.84522777.7
 
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.