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

112 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
preformed1717620(None) 
performed17155301performed
reformed14249601_reformed
deformed15248262_deformed
performer16145132performer
prearmed1397992pre_armed
preferred1555002preferred
prefired144310752prefir_ed
preform1439622preform__
preformat1646362preformat
preforms1537412preform_s
preinformed1952662preinformed
presorted1239452presorted
prewarmed17104562prewarmed
preworked1954652preworked
reforged13268702_reforged
reformer13217952_reformer
triformed1543732triformed
unreformed1643562unreformed
ausformed1542323ausformed
bewormed16235443_bewormed
biformed1643693_biformed
conformed1767463conformed
defoamed15356243_defoamed
deforced15247373_deforced
deformer14247943_deformer
dewormed15236223_dewormed
formed125021173___formed
informed14197673_informed
malformed1742383malformed
misformed1745243misformed
perforated1656893perforated
perforce1544963perforce_
perform1439293perform__
performers17164103performers
performs1547493perform_s
perfumed1654543perf_umed
permed115217353p_e__rmed
postformed1842923postformed
preboarded1663893preboarded
preboiled1455783preboiled
prebooked1863913prebooked
precoded1438863preco_ded
precooked1844993precooked
precooled1446363precooled
precured1339993precur_ed
predried12309573pre_dried
prefabbed1942323prefabbed
prefaced1638423pref_aced
prefaded1537823pref_aded
preferment1746323preferment
preferrer1443893preferrer
prefiled143310573pref_iled
prefilled1535513prefilled
prefire124012813prefir_e_
prefires134313283prefir_es
prefixed21357703pref_ixed
preflame1545913preflame_
prefocused1843443prefocused
preformats1744413preformats
preformatted2052273preformatted
preforming1846233preforming
prefroze2264673prefroze_
prefrozen2352843prefrozen
prefunded1644693prefunded
preloaded1335923preloaded
premed114617763pre___med
premolded1544683premolded
premorse1237553premorse_
prenomen1249633preno_men
preorder1136463pre_order
preowned1435213pre_owned
prepared132210873prepar_ed
prescored14409403prescor_ed
preserved15107563preserved
presoaked1635653presoaked
presolved1545273presolved
prestored125111673prestor_ed
presumed1337973pre_sumed
prewarned1594773prewarned
prewired14358473prewir_ed
proforma1545433proform_a
rearmed103912823_re_armed
rebored105015883_rebor_ed
recorded122511073_recorded
recorked15239863_recorked
refereed12149693_refereed
referred1297833_referred
refilmed14235813_refilmed
refired115116993_refir_ed
refolded1337063_refolded
reforge11259033_reforge_
reforges12249333_reforges
reform11312723_reform__
reformat1357653_reformat
reformers14246403_reformers
reforms1239823_reform_s
reframed1437853_reframed
refried113513883_ref_ried
regorged11227333_regorged
reinformed1664333_reinformed
reported11312703_reported
resorbed1138533_resorbed
resorted9313493_resorted
retorted9312333_retorted
rewarmed14257433_rewarmed
reworded13228103_reworded
reworked16247773_reworked
undeformed1743373undeformed
unformed14239573_unformed
uniformed1544533uniformed
unperformed1972493unperformed

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 Filter1786911486410.500357382.0
2DLD Change Limit1486411127.42320024.4
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.96922423.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.