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 “premieres” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
premieres1328823(None) 
premiere12249231premiere_
premiered14237081premiered
premiers122911651premier_s
prefires134313282prefi_res
premier113515632premier__
premies113823062premi__es
premises123018272premi_ses
premisses13288762premisses
premixes193110082premi_xes
prewires133811012prewi_res
bemires113212833_bemi_res
breviers1335923brevier_s
derrieres1044813derrieres
emigres1037673__emigres
eremites10312603eremi_tes
pismires1235883pismi_res
portieres1138213portieres
preavers13910263preaver_s
precedes13310703pre_cedes
precieuse1344613precieuse
precipes143212213preci_pes
precises123218333preci_ses
precures12312903pre_cures
preemies12512193preemi__es
preeners102712813preener_s
prefers123713333pre_fer_s
prefigures1643903prefigures
prefiles133113443prefi_les
prefire124012813prefi_re_
prefired144310753prefi_red
prefixes20389233prefi_xes
preggers12236833pregger_s
prelives13310383preli_ves
prematures1447053prematures
premeds12389583prem_e_ds
premeet11615153prem_e_et
premerger1444903prem_erger
premie103617993premi__e_
premiering1547243premiering
premise113818553premi_se_
premised133013193premi_sed
premiss113513813premi__ss
premiums1437533premi_ums
premixed20338003premi_xed
premorse1237553prem_orse
prepares122014163pre_pares
prerinses1138813prerinses
prescores133912173prescores
preserves14109073pre_serves
presiders1248213presider_s
presides11414913presi_des
pressers103215023presser_s
pressures1149063pressures
presters103419003prester_s
prestores114716083prestores
preterms1237223pre_terms
preverbs15295303pre_verbs
previewed1843413previewed
previewer1743023previewer
previewers1842563previewers
previews1634513previe_ws
previses133814283previ_ses
prewire124311133prewi_re_
prewired14358473prewi_red
prexies163415003prexi__es
preyers124412363pre_yer_s
priers84521193pr__ier_s
primeros12336883prim_eros
primers114215673prim_er_s
primines123013703primi_nes
priseres10310823pr_iseres
promines123018803promi_nes
promisees13246863promisees
promisers13268203promiser_s
promises122916763promi_ses
refires104820313_refi_res
rehires105016113_rehi_res
reliers75519213_relier_s
relieves114210393_relieves
remerges111110203_rem_erges
remiges103015473_remi_ges
remises93423483_remi_ses
remixes164313873_remi_xes
retirees84611653_retirees
retires74726213_reti_res
reveres103621343_re_veres
rewires104717113_rewi_res
rivieres1136013_rivieres

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641897.22020587.4
3Display Results89890.0302966.7
 (SQL Overall)178691897.40624127.9
 
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.