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 “pretaste” 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
pretaste1013952(None) 
prepaste12139081prepaste
pretasted12147961pretasted
pretastes11119421pretastes
retaste72313131_retaste
foretaste1295862foretaste
poetaster1145672poetaster
precast11314852precast_
precasts1239452precasts
predate10616892preda_te
prelate9519692prela_te
prepasted14137672prepasted
prepastes13128822prepastes
pretape113511622preta_pe
pretest9517632pretest_
pretested12149112pretested
pretests10310012pretests
retasted92412112_retasted
retastes82212902_retastes
acetate92514753aceta_te
artiste73813693ar_tiste
breast8319633bre_ast_
breasted1138823bre_asted
breasts939703bre_asts
crease85519573cre_as_e
create85126383cre_a_te
cremate113816183crema_te
crenate93317113crena_te
crevasse1343093crevasse
distaste939943distaste
foretasted1484753foretasted
foretastes1375593foretastes
grease75416233gre_as_e
metate82720533_meta_te
paste74932953p___aste
pease75231113p_e_as_e
pectase112410363pectas_e
pectate112214693pecta_te
pedate93117763p_eda_te
peltast9310513peltast_
peltasts1035703peltasts
peltate92013773pelta_te
pertest9317043pertest_
petabyte1542783p_etabyte
petasos948603p_etasos
petasus946363p_etasus
petite84320653p_et_ite
phenate12412203phena_te
pietas84516503pietas__
pietist9414033pietist_
pietists1038323pietists
please84315733ple_as_e
poetasters1245283poetasters
poetise9314043poetis_e
posthaste1456603posthaste
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
prepare111913623prepa_re
prepave14228873prepa_ve
prerace11414123prera_ce
presage10312293presa_ge
presale9416353presa_le
prese75228383pre__s_e
preset84430983pre__set
prest75736353pre__st_
prester93519623pre__ster
presto84216203pre__sto
prests84021263pre__sts
pretaped13339133pretaped
pretapes122811533pretapes
pretasting13239283pretasting
pretax152310193preta__x
pretence122312123pretence
pretense10199823pretense
preterite11613203preterite
pretext1639663pretext_
pretexted19135693pretexted
pretexts1735603pretexts
pretty11510873pret__ty
pretype14387483pret_ype
preunite1039573preunite
prevalue1345073prevalue
previse123713793previs_e
prewash1535213prewas_h
prewashed1843923prewashed
prewashes1744753prewashes
primate111516283prima_te
private121513263priva_te
probate11414483proba_te
proette9312363proet__te
prolate9419793prola_te
pronate9418873prona_te
prorate9418733prora_te
prostate10314533prosta_te
protases102115033protases
protasis102411973protasis
protease10209893proteas_e
protest9317533protest_
protested12159113protested
protester111510483protester
protests10310493protests
protist9320223protist_
protists10313363protists
rebate84424113_reba_te
recast83422773_recast_
recasts93413533_recasts
redate74124683_reda_te
refasten1136103_refasten
relate64033633_rela_te
remaster10311473_remaster
remate84428683_rema_te
repast83520633_repast_
repasted112611533_repasted
repasts93611933_repasts
restate73824883_resta_te
retable91820403_retable
retake104718533_reta_ke
retape83917683_reta_pe
retest64028453_retest_
retested92212533_retested
retests73813853_retests
retuse66617223_retus_e
rotate63320343_rota_te
taste55127233___taste
urease64516993ure_as_e

Search took 9 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.440406115.9
2DLD Change Limit1461621447.86018595.7
3Display Results1441440.0602400.0
 (SQL Overall)1786911448.36021374.5
 
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.