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

144 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
pretypes1533726(None) 
pretapes122811531pretapes
pretype14387481pretype_
pretyped16306121pretyped
retypes12308621_retypes
precipes143212212precipes
pretape113511622pretape_
pretaped13339132pretaped
pretties10615132pretties
protyles13249832protyles
retapes93917422_retapes
retype11399142_retype_
retyped13367302_retyped
antetypes1443733antetypes
archetypes2052563archetypes
aretes64425353aret__es
biotypes1544683biotypes
cerotypes1644733cerotypes
cotypes1437943_cotypes
crepes105419343cre__pes
ecotypes1545053ecotypes
ectypes1434803_ectypes
etapes85415293__etapes
isotypes13234853isotypes
metopes11311363_metopes
mistypes15116713mistypes
neotypes1344523neotypes
petites93820203p_etites
pettles93916483p_ettles
phenotypes2044633phenotypes
pieties9419223piet_ies
platypus1542353platypus
poetises10313953poetises
poetizes19310253poetizes
poetries10315583poetries
polytypes1945173polytypes
praecipes1544853praecipes
prates84633163prat__es
prattles10189403prattles
preaches153214893preaches
preamps1336613preamp_s
prebakes1639013prebakes
precedes13310713precedes
precepts14268893precepts
precipe133012123precipe_
precises123218333precises
precodes13711573precodes
precures12312903precures
predates11615813predates
predries112714383predries
preemies12512193preemies
preempts1444543preempts
prees75937173pre___es
prefaces15311063prefaces
prefades1439533prefades
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
pregames1339003pregames
prelates10418573prelates
prelives13310383prelives
preludes1137833preludes
premies113823063pre_mies
premises123018273premises
premixes193110083premixes
prenames12311643prenames
prentices131111903prentices
preops104911943pre_op_s
prepares122014163prepares
prepaves15189193prepaves
prepped11329903pre_pped
preppies1149683preppies
preps96220693pre__p_s
prepubes1436053prepubes
prepuces1438583prepuces
prepupas1144133prepupas
presages11312203presages
presales10315263presales
presbyopes1952203presbyopes
preshapes1667093preshapes
presides11414913presides
presses93523153pre_sses
prestiges12310593prestiges
prestores114716083prestores
presumes1239843presumes
pretastes11119423pretastes
preteen939873pret_een
preteens1038123preteens
pretells1047333pretells
pretences132312613pretences
pretends11299113pretends
pretense10199823pretense
pretenses112210593pretenses
preterms1237223preterms
pretest9517633pret__est
pretests10310013pretests
pretexts1735603pretexts
pretors9316813pret_ors
pretrims1238983pretrims
prettied1159253prettied
prettier1069043prettier
prettiest1199803prettiest
pretyping1764943pretyping
pretzel1835143pret_zel
pretzels1934033pretzels
previses133814283previses
prevues1239263pre_vues
prewires133811013prewires
prexes154915953pre__xes
prexies163415003pre_xies
preyed125313203pre_y_ed
preyer114413733pre_y_er
preyers124412363pre_yers
preys105717783pre_y__s
prezes173614693pre__zes
proettes10312763proet_tes
prostyles14157113prostyles
protases102115033protases
proteges1149923proteges
prototypes1745923prototypes
protyle12229453protyle_
protyls12298463proty_ls
recipes113314463_recipes
redyes104214093_redy_es
restyles1139193_restyles
retakes113718863_retakes
retape83917683_retape_
retaped103814283_retaped
retaxes143615093_retaxes
retches123318513_retches
retenes76324623_retenes
reties65436193_ret_ies
retiles74426993_retiles
retimes95020173_retimes
retines75134673_retines
retires74726213_retires
retries74129073_retries
retunes76918403_retunes
serotypes1445323serotypes
subtypes1544553subtypes
teletypes14114953teletypes
tintypes1343273tintypes
types105721063___types
wretches16257283wretches

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.423422437.4
2DLD Change Limit1461621447.46619577.0
3Display Results1441440.0632285.7
 (SQL Overall)1786911447.95222471.2
 
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.