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

146 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
pretype1438748(None) 
pretape113511621pretape
pretyped16306121pretyped
pretypes15337261pretypes
retype11399141_retype
precipe133012122precipe
pretaped13339132pretaped
pretapes122811532pretapes
protyle12229452protyle
retape83917682_retape
retyped13367302_retyped
retypes12308622_retypes
antetype1343513antetype
archetype1952353archetype
arete56031353aret__e
biotype1444423biotype
cerotype1544653cerotype
cotype1346823_cotype
crepe95520723cre__pe
ecotype1444843ecotype
ectype1334283_ectype
etape74413703__etape
isotype12224953isotype
metope10611123_metope
mistype14126523mistype
neotype1244593neotype
petite84320653p_etite
pettle84116053p_ettle
phenotype1944383phenotype
piety105817303piety__
platypi1442753platypi
poetise9314043poetise
poetize18310773poetize
polytype1844753polytype
praecipe1444633praecipe
prate75135983prat__e
prattle9208833prattle
preamp1238993preamp_
preamps1336613preamps
prebade12310283prebade
prebake1539093prebake
precede1239643precede
precept133112513precept
precipes143212213precipes
precise113518173precise
precode12311853precode
precure11312553precure
predate10616893predate
predive13511083predive
pree67044733pre___e
preemie11310563preemie
preempt1337723preempt
preface14510923preface
prefade1339013prefade
prefile123413183prefile
prefire124012813prefire
pregame1239553pregame
prelate9519693prelate
prelife1279943prelife
prelude1038013prelude
premade12311443premade
premie103617993pre_mie
premise113818553premise
premune1138933premune
prename11412643prename
prentice121012353prentice
preop94715873pre_op_
preops104911943pre_ops
prep86427673pre__p_
prepare111913623prepare
prepave14228873prepave
prepped11329893pre_pped
preppie1058093preppie
preppy1235523pre_ppy
preps96220693pre__ps
prepuce1337833prepuce
prepupa1064023prepupa
prepupae1144643prepupae
prerace11414123prerace
presage10312293presage
presale9416353presale
presbyope1842453presbyope
prese75228383pre__se
preshape1537533preshape
preside10715613preside
prestige11310733prestige
prestore104217343prestore
presume11310303presume
pretaste10139523pretaste
pretax152310193pret_ax
preteen939873preteen
pretell938233pretell
pretence122312123pretence
pretend104011013pretend
pretense10199823pretense
preterm11310153preterm
pretest9517633pretest
pretext1639663pretext
pretold1049083pretold
pretor8315743pret_or
pretors9316803pretors
pretrim11310783pretrim
prettied1159253prettied
prettier1069043prettier
pretties10615133pretties
pretty11510873pret_ty
pretyping1764943pretyping
pretzel1835143pretzel
previse123713793previse
prevue1179163pre_vue
prewire124311133prewire
prexy174611573prexy__
prey96228483pre_y__
preyed125313193pre_yed
preyer114413733pre_yer
preys105717783pre_y_s
prithee1239933prithee
proette9312363proet_te
prostyle13187273prostyle
protege1059153protege
prototype1645663prototype
protyl11308213proty_l
protyles13249833protyles
protyls12298463protyls
prythee1545383prythee
recipe103414893_recipe
redye94413463_redy_e
restyle1038763_restyle
retake104718533_retake
retaped103814283_retaped
retapes93917423_retapes
rete44944133_ret__e
retene69224273_retene
retie55735303_ret_ie
retile65929673_retile
retime85321803_retime
retine66237333_retine
retire64927013_retire
retore67630763_retore
retune69121953_retune
retuse66617223_retuse
serotype1345163serotype
subtype1444203subtype
teletype1394543teletype
tintype1243033tintype
type96223743___type

Search took 10 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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271468.95614965.1
3Display Results1461460.0463173.9
 (SQL Overall)1786911469.15519518.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.