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

113 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
premiums143753(None) 
premium13310361premium_
fermiums1544352fermiums
prelims1139822preli_ms
premiers122911652premiers
premies113823062premi_es
premises123018272premises
premiss113513812premi_ss
premixes193110082premixes
protiums1238552protiums
bromisms1436403bromisms
cadmiums1544403cadmiums
caesiums1245533caesiums
ceriums1139473_ceriums
cesiums1136303_cesiums
chemisms17278213chemisms
chromiums1844543chromiums
coremium1446413coremium_
craniums1297913craniums
creminis12208253creminis
crumbums1642733crumbums
erbiums1135463er_biums
eremites10312603eremites
fermium1446353fermium_
fremitus1344023fremitus
frenums1236203fre_nums
gremials1136133gremials
heliums12188303_heliums
holmiums1544153holmiums
iridiums1144523iridiums
mediums12308723_mediums
osmiums1134143_osmiums
palliums1236703palliums
parecisms1547163parecisms
peplums13145503p_eplums
permits11314003permi_ts
pietisms1247463pietisms
plenisms1237963plenisms
plenums1136533ple_nums
plumbums1642943plumbums
podiums12227633p_odiums
prearms11369173pre_arms
prebids12399883prebi_ds
prebills1237293prebills
prebinds13357733prebinds
prebuys1444393pre_buys
precious12310593precious
precipes143212213precipes
precis103416703preci__s
precises123218333precises
precuts111710473pre_cuts
predicts1339613predicts
preemies12512193preemi_es
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
preforms1537403preforms
prelim10311423preli_m_
prelives13310383prelives
premeds12389593prem_eds
premie103617993premi__e
premier113515633premi_er
premiere12249233premiere
premieres13288233premieres
premise113818553premi_se
premised133013193premised
premisses13288763premisses
premix173710333premi__x
premixed20338013premixed
premixt183510663premi_xt
premolds1345843premolds
premune1138933prem_une
presides11414913presides
presidiums1543403presidiums
presifts1366593presifts
presume11310303pre_sume
presumes1239843pre_sumes
preterms1237223preterms
pretrims1238983pretrims
previews1634513previews
previous1337823previous
previses133814283previses
prevues1239263pre_vues
prewarms15406733prewarms
prewires133811013prewires
prexies163415003prexi_es
primines123013703primines
primings13338143primings
prims95425933pr__i_ms
primus103712173prim_u_s
prisms104915503pr__isms
promines123018803promines
promises122916763promises
protium11312293protium_
pyemias1436803pyemi_as
radiums10299313_radiums
rectums11338523_rectums
refilms12347503_refilms
regius7311923_regiu_s
remiges103015473_remiges
reminds104614793_reminds
remints95117293_remints
remises93423483_remises
remiss84216353_remi_ss
remits85622943_remi_ts
remixes164313873_remixes
rheniums1344413rheniums
tediums10266973_tediums
terbiums1245423terbiums
tritiums1056393tritiums
uraniums10117163uraniums
uredium1076693uredium_
uremias9249503uremi_as

Search took 9 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.436409841.7
2DLD Change Limit1461621137.76618820.8
3Display Results1131130.0462456.5
 (SQL Overall)1786911138.24821664.8
 
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.