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

151 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
prepasted1413767(None) 
prepaste12139081prepaste_
prepastes13128821prepastes
pretasted12147961pretasted
repasted112611531_repasted
breasted1138822bre_asted
preacted132710942pre_acted
predated12513272preda_ted
prepacked20155652prepacked
prepared132210872prepa_red
prepaved16177232prepa_ved
pretaste10139522pretaste_
pretastes11119422pretastes
pretested12149112pretested
prewashed1843922prewashed
repassed11229272_repassed
retasted92412112_retasted
breastfed1542693bre_astfed
creased104315583cre_as_ed
created104323453cre_a_ted
cremated133412963crema_ted
crenated113013913crena_ted
crested103416533cre__sted
crevassed1543193crevassed
demasted1238763_demasted
departed1238823_departed
feasted11310843_fe_asted
forecasted1685103forecasted
forepassed1643063forepassed
foretasted1484753foretasted
greased93812393gre_as_ed
impasted13297553_impasted
palpated13249763palpa_ted
pasted94426903___pasted
persisted1247143persisted
pleased103712073ple_as_ed
pleated103816633ple_a_ted
poetaster1145673poetaster
prated94924923pr__a_ted
preached163412063pre_ached
preadapted1643733preadapted
preaged11612333pre_a_ged
prealter1048863pre_alter
prearmed1397993pre_armed
prebaked1737173preba_ked
precast11314853precast__
precasts1239453precast_s
precented14310693precented
precessed1437523precessed
precised133213413precis_ed
precited133013813pre_cited
predate10616893preda_te_
predates11615813preda_tes
predicted1538913predicted
preedited1337633preedited
preempted1644683preempted
preenacted1544973preenacted
preexisted2043783preexisted
prefabbed1942323prefabbed
prefaced1638423prefa_ced
prefaded1537823prefa_ded
preheated1539813preheated
prelate9519693prela_te_
prelates10418573prela_tes
prelected1439133prelected
premised133013193premis_ed
prepaid12310133prepa__id
prepare111913623prepa_re_
preparer12169643prepa_rer
prepares122014163prepa_res
prepasting15168883prepasting
prepave14228873prepa_ve_
prepaves15189193prepa_ves
preplaced1676483preplaced
preplanned1543503preplanned
prepped11329903prep__ped
prepriced1676643prepriced
preprinted1546543preprinted
presaged1238803presa_ged
presented12311633presented
presifted1536873presifted
presorted1239453presorted
pressed103317313pre__ssed
prester93519623pre__ster
pretaped13339133preta_ped
pretexted19135693pretexted
preunited1246803preunited
prevailed1536043prevailed
prevalued1544553prevalued
prevented1539003prevented
prevised143611073previs_ed
previsited1645183previsited
prewarmed17104563prewarmed
prewarned1594773prewarned
prewashes1744753prewashes
priested1138393pr_iested
probated13410863proba_ted
pronated11414053prona_ted
propagated1644633propagated
proplastid1556753proplastid
proposed132011073propos_ed
prorated11513713prora_ted
protested12159113protested
pupated12319353p_upa_ted
reacted103015713_re_acted
rebaited11410543_rebaited
rebated103619703_reba_ted
recanted112513513_recanted
redacted12410243_redacted
redated93120923_reda_ted
reested82916233_re_ested
refasten1136103_refasten
rehashed1536063_rehashed
related83327573_rela_ted
relisted9312623_relisted
remaster10311473_remaster
remated103522473_rema_ted
renested92212953_renested
repacked17188743_repacked
repainted1277863_repainted
repaired1148953_repaired
reparked15208923_reparked
repartee10312753_repartee
repasses101810373_repasses
repast83520633_repast__
repasts93611933_repast_s
repaved133311133_repa_ved
repeated113117443_repeated
repented112614983_repented
replanted1248063_replanted
replaster1136583_replaster
replated112817523_replated
reported11312703_reported
reposed103616273_repos_ed
reposited1239133_reposited
repotted1139283_repotted
reputed104613483_rep_uted
resisted9312693_resisted
rested74430783_re__sted
retaste72313133_retaste_
retastes82212903_retastes
retested92212533_retested
revested122612243_revested
rewashed1546243_rewashed
riposted11216933_riposted
roasted83912663_r_oasted
treated83618703tre_a_ted
trepanned1243913trepanned
trespassed1341923trespassed
wrested113410933wre__sted
yeasted1138503_ye_asted

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411516.40623203.4
3Display Results1511510.0632396.8
 (SQL Overall)1786911516.89225927.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.