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

130 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
prepaste1213908(None) 
prepasted14137671prepasted
prepastes13128821prepastes
pretaste10139521pretaste
precast11314852precast_
precasts1239452precasts
predate10616892preda_te
prelate9519692prela_te
prepare111913622prepa_re
prepave14228872prepa_ve
pretasted12147962pretasted
pretastes11119422pretastes
repast83520632_repast_
repasted112611532_repasted
repasts93611932_repasts
retaste72313132_retaste
arepas85515703arepas__
breast8319633bre_ast_
breasted1138823bre_asted
breasts939703bre_asts
crease85519573cre_as_e
create85126383cre_a_te
cremate113816183crema_te
crenate93317113crena_te
crevasse1343083crevasse
forepast1348043forepast_
foretaste1295863foretaste
grease75416233gre_as_e
impaste11258003_impaste
palpate113213923palpa_te
paste74932953___paste
pease75231113p_e_as_e
pedate93117763p_eda_te
phenate12412193phena_te
please84315733ple_as_e
poetaster1145673poetaster
prase76128753pr__as_e
prate75135983pr__a_te
preact103220393pre_act_
preacted132710943pre_acted
preacts113211363pre_acts
prealter1048863pre_alter
prebade12310283preba_de
prebake1539093preba_ke
prebasal1244723prebasal
prebattle1343013prebattle
precavae1544813precavae
precise113518173precis_e
predated12513273preda_ted
predates11615813preda_tes
preface14510923prefa_ce
prefade1339013prefa_de
pregame1239553prega_me
prelates10418573prela_tes
premade12311443prema_de
premise113818553premis_e
prename11412643prena_me
prepack1757643prepa_ck
prepacked20155653prepacked
prepacks1836583prepacks
prepaid12310133prepa_id
prepared132210873prepared
preparer12169643preparer
prepares122014163prepares
prepasting15168883prepasting
prepaved16177233prepaved
prepaves15189193prepaves
prepay13310313prepa__y
prepays1437483prepa_ys
prepense12238943prepense
preplace1488983preplace
preplant12712913preplant_
preppie1058093prep_pie
preprice1488873preprice
preps96220693prep_s__
prepuce1337833prep_uce
prepupae1144643prepupae
prerace11414123prera_ce
presage10312293presa_ge
presale9416353presa_le
prese75228383pre__s_e
preset84430983pre__set
prest75736353pre__st_
prester93519623pre__ster
presto84216203pre__sto
prests84021263pre__sts
pretape113511623preta_pe
pretest9517633pretest_
pretested12149113pretested
pretests10310013pretests
preunite1039573preunite
prevalue1345073prevalue
previse123713793previs_e
prewash1535213prewas_h
prewashed1843923prewashed
prewashes1744753prewashes
primate111516283prima_te
private121513263priva_te
probate11414483proba_te
prolate9419793prola_te
pronate9418873prona_te
propagate1446123propagate
propane112716153propa_ne
prophase15410243prophas_e
propose112714843propos_e
prorate9418733prora_te
psephite1543843psephite
pupate104213123p_upa_te
rebate84424113_reba_te
recast83422773_recast_
recasts93413533_recasts
redate74124683_reda_te
refasten1136103_refasten
relate64033633_rela_te
remaster10311473_remaster
remate84428683_rema_te
repartee10312753_repartee
repass84114703_repas_s
repassed11229273_repassed
repasses101810373_repasses
repave114813873_repa_ve
replaster1136583_replaster
replate93420053_replate
replete92912993_replete
repose84121413_repos_e
repute84716093_rep_ute
retasted92412113_retasted
retastes82212903_retastes
riposte9269623_riposte
urease64516993ure_as_e

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.406440125.6
2DLD Change Limit1461621306.43622710.1
3Display Results1301300.0462826.1
 (SQL Overall)1786911306.88825942.4
 
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.