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

126 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
premiere1224923(None) 
premier113515631premier_
premiered14237081premiered
premieres13288231premieres
premiers122911651premiers
prefire124012812prefi_re
premie103617992premi__e
premies113823062premie_s
premise113818552premi_se
prewire124311132prewi_re
bemire103312803_bemi_re
brevier1237763brevier_
breviers1335923breviers
creamier12319063creamier_
crepier1139733crepier_
derriere936043derriere
dreamier11287293dreamier_
emigre937053__emigre
eremite9312833eremi_te
germier10309543germier_
grimier103210433grimier_
palmier113312173palmier_
perkier133813123perkier_
pismire1135353pismi_re
plumier113510043plumier_
portiere1038773portiere
preaver121011613preaver_
preavers13910263preavers
precede1239643pre_cede
precieuse1344613precieuse
precieux1943033precieux
precipe133012123preci_pe
precise113518173preci_se
preciser123411663preciser_
precure11312553pre_cure
predive13511083predi_ve
preemie11310563preemi__e
preemies12512193preemie_s
preener93114833preener_
preeners102712813preeners
prefer113813203pre_fer_
prefers123713333pre_fers
prefigure1544043prefigure
prefile123413183prefi_le
prefired144310753prefired
prefires134313283prefires
preggers12236833preggers
prelife1279943preli_fe
premade12311443prem_ade
premature1347783premature
premeal11310513prem_eal
premed114617753prem_e_d
premeds12389583prem_eds
premeet11615153prem_eet
premen105017803prem_e_n
premerger1444903prem_erger
premiering1547243premiering
premised133013193premised
premises123018273premises
premiss113513813premi_ss
premisses13288763premisses
premium13310363premi_um
premiums1437533premiums
premix173710333premi__x
premixed20338003premixed
premixes193110083premixes
premixt183510663premi_xt
premodern1444423premodern
premorse1237553premorse
premune1138933prem_une
prepare111913623pre_pare
preppier1156643preppier_
prerinse1038633prerinse
prescore124812363prescore
preserve13108803pre_serve
preside10715613presi_de
presider11410423presider_
presiders1248213presiders
presser93717623presser_
pressers103215023pressers
pressure1039773pressure
prester93519623prester_
presters103419003presters
prestore104217343prestore
preterm11310153pre_term
prettier1069043prettier_
preverb14317063pre_verb
preview1536473previe_w
previewed1843413previewed
previewer1743023previewer
previews1634513previews
previse123713793previ_se
prewired14358473prewired
prewires133811013prewires
prexies163415003prexie_s
preyer114413733pre_yer_
preyers124412363pre_yers
pricier113313113pricier_
prier75027763pr__ier_
priers84521193pr__iers
primer105118683prim_er_
primero11368923prim_ero
primers114215673prim_ers
primine113214823primi_ne
primmer134310163primmer_
prisere9310943pr_isere
privier122910453privier_
promine112819443promi_ne
promise113415843promi_se
promisee122711333promisee
promiser122510673promiser_
promisers13268203promisers
prosier93817483prosier_
refire95419473_refi_re
rehire95415863_rehi_re
relier65826183_relier_
reliers75519213_reliers
relieve105010693_relieve
remerge10148923_rem_erge
remise84221953_remi_se
retire64927013_reti_re
retiree75019083_retiree
revere94621253_re_vere
rewire95421403_rewi_re
rimier83916273_rimier_
riviere1036373_riviere

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.190940478.9
2DLD Change Limit1461621267.53019410.6
3Display Results1261260.0632000.0
 (SQL Overall)1786911267.78322959.1
 
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.