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

247 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
pretaped1333913(None) 
pretape113511621pretape_
pretapes122811531pretapes
pretyped16306121pretyped
retaped103814281_retaped
petaled103614142p_etaled
preaged11612332pre_aged
prebaked1737172prebaked
predated12513272predated
prefaced1638422prefaced
prefaded1537822prefaded
prepared132210862prepared
prepaved16177222prepaved
prepped11329892pre_pped
presaged1238802presaged
preshaped1745522preshaped
prestamped1742952prestamped
pretasted12147962pretasted
prettied1159252prettied
pretype14387482pretype_
pretypes15337252pretypes
reaped94122452_re_aped
retape83917682_retape_
retapes93917422_retapes
retaxed153512232_retaxed
retyped13367302_retyped
acetated112010683acetated
betaxed17307023_betaxed
breaded115014063bre_aded
breamed124011593bre_amed
breathed14469643breathed
craped116120523cr__aped
creaked143413233cre_aked
creamed123913713cre_amed
creased104315583cre_ased
created104323443cre_ated
creeped12329713cre_eped
cremated133412963cremated
crenated113013913crenated
creped114115703cre__ped
draped105314363dr__aped
dreaded103612023dre_aded
dreamed114310633dre_amed
etape74413703__etape_
etapes85415293__etapes
freaked15399703fre_aked
fretted113411853fret_ted
greased93812393gre_ased
greaved12408913gre_aved
heaped124516903_he_aped
leaped94317773_le_aped
metaled102913873_metaled
peaced115818913p_e_aced
peaked136117403p_e_aked
pealed95322803p_e_aled
pedaled113711873p_edaled
peeped113915383p_e_eped
pepped103113393p_e_pped
pertained1238493pertained
pervaded1535363pervaded
petalled1138683p_etalled
petard95013803p_eta_rd
petered103314963p_etered
petnaper1243913p_etnaper
petnapped1342383p_etnapped
petted94121523p_et_ted
pettled103611503p_ettled
phreaked1834493phre_aked
pleaded113511263ple_aded
pleased103712073ple_ased
pleated103816633ple_ated
poetised1138523poetised
poetized2037973poetized
portaged12228463portaged
portaled11239203portaled
prated94924923pr__ated
prattled11246533prattled
prayed124815433pr__ayed
preached163412063preached
preacted132710943preacted
preadapted1643733preadapted
prearmed1397983prearmed
preaver121011613pre_aver
prebade12310283prebade_
prebake1539093prebake_
prebakes1639003prebakes
preceded1438283preceded
precipe133012123precipe_
precipes143212213precipes
precised133213413precised
precited133013813precited
precoded1438863precoded
precured1339993precured
predate10616893predate_
predates11615803predates
predried12309573predried
preed85128113pre___ed
preempted1644673preempted
preened103214983pre_ened
prefabbed1942323prefabbed
preface14510923preface_
prefacer1537983prefacer
prefaces15311063prefaces
prefade1339013prefade_
prefades1439533prefades
prefiled143310573prefiled
prefired144310753prefired
prefixed21357693prefixed
pregame1239553pregame_
pregames1339003pregames
preheated1539813preheated
prelate9519693prelate_
prelates10418563prelates
preloaded1335923preloaded
preluded1236453preluded
premade12311443premade_
premed114617753pre__med
premised133013193premised
premixed20338003premixed
prename11412643prename_
prenames12311633prenames
prenticed14118063prenticed
preowned1435213preowned
prepacked20155643prepacked
prepaid12310133prepa_id
prepare111913623prepare_
preparer12169643preparer
prepares122014163prepares
prepasted14137663prepasted
prepave14228873prepave_
prepaves15189193prepaves
preplaced1676453preplaced
prerace11414123prerace_
presage10312293presage_
presager1138443presager
presages11312203presages
presale9416353presale_
presales10315263presales
preshape1537533preshape_
preshapes1667083preshapes
presided12410553presided
presoaked1635653presoaked
pressed103317303pre_ssed
prestored125111673prestored
presumed1337963presumed
pretaping1439133pretaping
pretaste10139523pretaste
pretastes11119423pretastes
pretax152310193preta__x
preteen939873pret_een
pretend104011013pret_end
pretended1337193pretended
pretested12149113pretested
pretexted19135683pretexted
pretold1049083pret_old
pretrained1357063pretrained
pretravel1444123pretravel
pretreated1347623pretreated
prettier1069043prettier
pretties10615133pretties
pretzel1835143pret_zel
prevailed1536043prevailed
prevalued1544553prevalued
prevised143611073prevised
prevued1337143pre_vued
prewarmed17104563prewarmed
prewarned1594773prewarned
prewashed1843923prewashed
prewired14358473prewired
prewrapped1762163prewrapped
preyed125313193pre__yed
primped14479153pr_imped
probated13410863probated
profaned14207973profaned
prolapsed14133733prolapsed
pronated11414053pronated
propped113311953pr_opped
prorated11513713prorated
protases102115033protases
protopod1347353protopod
raped85334623_r__aped
reamed94326123_re_amed
reaper84223143_re_aper
reared75930013_re_ared
reaved104523923_re_aved
rebated103619693_rebated
recaned102817203_recaned
recapped1535943_recapped
redated93120923_redated
refaced133713573_refaced
regaled93615953_regaled
relaced103517213_relaced
relapsed1136523_relapsed
related83327573_related
relaxed153312523_relaxed
relayed113212753_relayed
remapped1534913_remapped
remated103522473_remated
renamed103114523_renamed
repaper11310023_repaper
repaved133311133_repaved
repped114616723_re_pped
resawed113111183_resawed
reshaped1437203_reshaped
restaged103011853_restaged
restamped1444433_restamped
restated93120173_restated
retacked15169273_retacked
retagged1136063_retagged
retailed94113963_retailed
retained93016093_retained
retake104718533_retake_
retaken113911803_retaken
retaker113714313_retaker
retakes113718863_retakes
retard75018933_reta_rd
retarded102410753_retarded
retasted92412113_retasted
retaxes143615093_retaxes
retched133814273_retched
reteamed1138013_reteamed
retied75924983_ret_ied
retiled84420513_retiled
retimed104714653_retimed
retired84620143_retired
retraced111413023_retraced
retried84419153_retried
retted74826313_ret_ted
retuned86613973_retuned
retype11399143_retype_
retypes12308623_retypes
revamped1634143_revamped
rewaked153811903_rewaked
rewaxed18409343_rewaxed
rotated82715293_rotated
sneaped10338813sne_aped
taped85327423___taped
threaped1454863thre_aped
treaded95014283tre_aded
treated83618703tre_ated
upheaped1633643uphe_aped
upleaped1334333uple_aped
upreared1137073upre_ared
wiretapped1851773wiretapped
wreaked15369023wre_aked
wreathed15257463wreathed
wretched17276533wretched

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.216827273.1
2DLD Change Limit1461622477.64319123.6
3Display Results2472470.0932655.9
 (SQL Overall)1786912477.95222471.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.