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

124 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
premorse123755(None) 
remorse9311711_remorse
premise113818552prem_ise
premoral1249712premoral
pretors9316812pretors_
primrose1244502primrose
remorses10311992_remorses
tremors93711232tremors_
arenose7311373areno_se
armors85017813ar_mors_
grumose1035723grumo_se
memorise121411433_memorise
morse76032703___morse
perforce1544963perforce
permease1246503permease
perse75429523p_e__rse
perverse1336103perverse
plexors1645423plexors_
plumose1135963plumo_se
praetors1039833praetors_
prechoose16105633prechoose
prechose15129773prechose
precise113518173pre_cise
precode12311853preco_de
precodes13711573precodes
precure11312553precur_e
precures12312903precures
prefers123713333prefers_
prefire124012813prefir_e
prefires134313283prefires
preform1439613prefor_m
preformed17176203preformed
preforms1537403preforms
prefroze2264673prefroze
preimpose1544013preimpose
premade12311443prem_ade
premarket17127853premarket
premeds12389593premeds_
premerger1444903premerger
premie103617993prem__ie
premiere12249233premiere
premieres13288233premieres
premiers122911653premiers_
premies113823063premies_
premised133013193prem_ised
premises123018273prem_ises
premiss113513813prem_iss
premisses13288763premisses
premixes193110083premixes
premoisten14124113premoisten
premolar1246633premolar
premolars1345023premolars_
premold1247863premo_ld
premolded1544683premolded
premolds1345843premolds
premolt11312073premo_lt
premonish1646803premonish
premune1138933prem_une
preops104911943pre_ops_
preoral9312673pre_oral
preorder1136463pre_order
prepare111913623prepar_e
prepares122014163prepares
prepense12238943prepense
prerinse1038633prerinse
prescore124812373prescor_e
prescores133912173prescores
prese75228383pre___se
preserve13108803preserve
presolve1347073presolve
presort95219543presor_t
presorted1239453presorted
presorts105311683presorts
pressors103212693pressors_
prestore104217353prestor_e
prestores114716083prestores
pretense10199823pretense
pretor8315753pretor__
previse123713793pre_vise
prewire124311143prewir_e
prewires133811013prewires
prework164210913prewor_k
preworked1954653preworked
preworks17599013preworks
preworn124711223prewor_n
preyers124412363preyers_
primers114215673primers_
primos104514423primo_s_
primroses1344843primroses
priors83914483pr_iors_
promise113415843prom_ise
promos105116423promo_s_
promote11313143promo_te
promotes12314123promotes
propose112714843propo_se
prose75835123pr__o_se
ramose8314403_ramo_se
rebore86625653_rebor_e
rebores95319163_rebores
recourse1038383_recourse
redhorse1245463_redhorse
reforge11259033_reforge
regorge9257833_regorge
rehouse10311773_rehouse
remerge10148923_remerge
remise84221953_rem_ise
remora8414593_remor_a
remoras9314073_remoras
remorid10311863_remorid
remote84222603_remo_te
remotes94521613_remotes
remove116115573_remo_ve
removes124514713_removes
repose84121413_repo_se
reremouse1143793reremouse
rerose63320843_rero_se
retore67630773_retor_e
retrorse837623_retrorse
reverse103913743_reverse
rewore938030163_rewor_e
rimose8310593_rimo_se
rumors81110403_rumors_
termors94712773termors_
tremor84210403tremor__

Search took 7 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.420425454.8
2DLD Change Limit1461621246.39022873.6
3Display Results1241240.0502480.0
 (SQL Overall)1786911246.86026048.3
 
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.