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

140 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
preforms153740(None) 
performs1547481performs
preform1439611preform_
reforms1239821_reforms
deforms1337802_deforms
paraforms1645562paraforms
perform1439282perform_
pieforts1344862pieforts
prearms11369172pre_arms
prefers123713332prefer_s
prefires134313282prefires
prefocus1544742prefocus
preformat1646362preformat
preformats1744412preformats
preformed17176202preformed
preinforms1743232preinforms
presorts105311682presorts
preterms1237222preterms
pretors9316812pretor_s
prewarms15406732prewarms
preworks17599012preworks
proforma1545432proforma
reform11312712_reform_
ausforms1343933ausforms
beworms1437933_beworms
conforms1538873conforms
defoams1336193_defoams
deform1259623_deform_
deworms1338033_deworms
fireworms1745603fireworms
forms105327053___forms
freeform1644703freeform_
informs1248073_informs
isoforms1344343isoforms
misforms1545893misforms
paraform1546933paraform_
pelorus939273p_elorus
perforce1544963perforce
performed17155303performed
performer16145133performer
performers17164103performers
perms95524513p_e__rms
phenoms1437813pheno_ms
piedforts1542483piedforts
piefort1249533piefor_t
pinworms15115783pinworms
piriform1555753piriform_
pisiforms1643493pisiforms
planforms1643723planforms
platforms1643203platforms
plexors1645423plexor_s
postforms1644603postforms
praetors1039833praetor_s
prearm104512353pre_arm_
preboards1446423preboards
preboils1267293preboils
prebooks1656303prebooks
preboom1348253preboom_
precodes13711573precodes
precooks1656763precooks
precools1237703precools
precures12312903precures
prefabs1435163pref_abs
prefaces15311063prefaces
prefades1439533prefades
prefects1598133prefects
prefer113813203prefer__
prefiles133113443prefiles
prefire124012813prefir_e
prefired144310753prefired
prefixes20389233prefixes
preflame1545913preflame
preforming1846233preforming
prefroze2264673prefroze
prefunds1454693prefunds
preinform1644753preinform_
prelims1139823pre_lims
preloads1157513preloads
premiums1437533premiums
premolds1345843premolds
premoral1249713premoral
premorse1237553premorse
preops104911943pre_o_ps
preoral9312673pre_oral
prepares122014163prepares
prereform1644303prereform_
prescores133912173prescores
presoaks1436603presoaks
presort95219543presor_t
pressors103212693pressor_s
prestores114716083prestores
preterm11310163preterm_
pretor8315753pretor__
pretrims1238983pretrims
preverbs15295303preverbs
prewarm14479613prewarm_
prewarns13456943prewarns
prewires133811013prewires
prework164210913prewor_k
preworn124711223prewor_n
preyers124412363preyer_s
priors83914483pr_ior_s
proems104711163pr__oems
proms95426413pr__o_ms
proreform1643903proreform_
pyriform1844403pyriform_
rearms85114653_re_arms
rebores95319163_rebores
records105213923_records
recorks134813023_recorks
refers93921083_refer_s
refilms12347503_refilms
refires104820313_refires
refocus1236973_refocus
refolds11298953_refolds
reforest1139963_reforest
reforge11259033_reforge
reforges12249333_reforges
reformat1357653_reformat
reformats1445713_reformats
reformed14249603_reformed
reformer13217953_reformer
reformers14246403_reformers
reformism1643703_reformism
reformist1445913_reformist
reinforms1445083_reinforms
remoras9314073_remoras
reports94916213_reports
resorbs95010523_resorbs
resorts74817193_resorts
retorts76016513_retorts
rewarms12439603_rewarms
rewords115413983_rewords
reworks145113603_reworks
trefoils1145303trefoils
tremors93711233tremor_s
triform1237853triform_
uniforms1355043uniforms
waveforms2042403waveforms
wireworms1745033wireworms

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 Limit1461621407.73618893.7
3Display Results1401400.0602333.3
 (SQL Overall)1786911408.23221706.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.