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

413 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
predates1161582(None) 
predate10616891predate_
predated12513271predated
prelates10418581prelates
redates83423881_redates
creates95225212cre_ates
cremates124216012cremates
depredates1445512depredates
foredates13310062foredates
gradates10510782gradates
pedate93117762p_edate_
penates93321602p_enates
phenates13611582phenates
prates84633162pr__ates
prebakes1639012prebakes
predatism1447292predatism
predator11310062predator
predators12310092predators
predawns1444362predawns
predeaths1544752predeaths
predicates15410832predicates
predries112714382predries
prefaces15311062prefaces
prefades1439532prefades
pregames1339002pregames
prelate9519692prelate_
prenames12311642prenames
prepares122014162prepares
prepastes13128822prepastes
prepaves15189192prepaves
presages11312202presages
presales10315262presales
pretapes122811532pretapes
pretastes11119422pretastes
primates121515932primates
privates131812382privates
probates12414282probates
pronates10418372pronates
prorates10418072prorates
rebates95123192_rebates
redate74124682_redate_
redated93120922_redated
relates73731442_relates
remates93827122_remates
sedates83418042_sedates
acetates102013073acetates
aerates74627503_aerates
agemates111110033agemates
airdates939733airdates
antedates1048623antedates
arenites8917133arenites
aretes64425363are__tes
arsenates979383arsenates
bedmates1349193_bedmates
berates94126883_berates
breadths1474473breadths
breathes134212913bre_athes
breaths124411203bre_aths
bredes94818473bred__es
brewages1436393brewages
bromates12413153bromates
caudates11310263caudates
cerates95428253_cerates
chedites1438263chedites
chelates132713853chelates
corelates11314873corelates
crates85736063cr__ates
creases94020963cre_ases
create85126383cre_ate_
created104323463cre_ated
credited1238253credited
credits1039983credit_s
cremate113816183cremate_
cremated133412963cremated
crenate93317113crenate_
crenated113013913crenated
crewmates16375813crewmates
crudites1137763crudites
dates65639153___dates
debates103718533_debates
delates83526283_delates
deprecates1547293deprecates
depredate1345733depredate_
depredated1544813depredated
derates84028893_derates
dredges10379353dred_ges
elates65032363__elates
elevates111110433elevates
emendates1246083emendates
enates64026433__enates
eradiates102010793eradiates
eremites10312613eremites
ergates8314493er_gates
exudates1636623exudates
ferrates113013423ferrates
foredate12310913foredate_
foredated1447683foredated
frigates12310933frigates
gelates83219593_gelates
gradate9511233gradate_
gradated1157433gradated
graduates1147683graduates
grates75429893gr__ates
greases84816713gre_ases
greaten83610643gre_aten
greatens9307593gre_atens
greater84416493gre_ater
greatest939873gre_atest
greats76318403gre_at_s
greaves113311443gre_aves
grenades1038433grenades
ideates8313733ide_ates
imprecates1645413imprecates
iodates8312903_iodates
iterates81317823iterates
legates82917683_legates
mandates11314093mandates
mediates112814073_mediates
metates92720013_metates
misdates111113633misdates
negates83215843_negates
nidates8311893_nidates
oleates7417833ole_ates
operates10515413operates
orates64328613or__ates
outdates93114743outdates
oxidates1636333oxidates
palates93624943p_alates
palpates122613063palpates
pates76047893p___ates
peaces106324083p_e_aces
peages94321853p_e_ages
peases85229473p_e_ases
peats76140193p_e_at_s
pectates122213953pectates
pedaled113711893p_edaled
pedaler103410693p_edaler
pedalers11239393p_edalers
pedalos10329703p_edalos
pedals94316033p_eda_ls
pedants10310113p_edants
pedately1445433p_edately
peddles112913703p_eddles
pedes85327293p_ed__es
peerages1189893peerages
pelages10714613p_elages
pelites93821993p_elites
percales12313803percales
perdues103511333perd_ues
perdures11289683perdures
perennates1256773perennates
periodates1347863periodates
perlites10316363perlites
permeates13311773permeates
permutes1238713permutes
perorates11417023perorates
pervades1437353pervades
pesades10310903p_esades
petites93820203p_etites
peyotes1238483p_eyotes
phenate12412203phenate_
phonates13410643phonates
phorates13413043phorates
picrates122013213picrates
pirates93020333p_irates
placates12311763placates
plates85432243p__lates
playdates1554903playdates
pleases94515483ple_ases
pleated103816633ple_ated
pleater93916333ple_ater
pleaters103613793ple_aters
pleats85218593ple_at_s
pledgees12376283pledgees
pledges113811583pled_ges
pledgets12365673pledgets
pleiades1145753pleiades
podites103014733p_odites
postdates1248863postdates
prases84429023pr__ases
prate75135983pr__ate_
prated94924923pr__ated
prater84825353pr__ater
praters94921653pr__aters
prats76333393pr__at_s
praxes156215183pr__axes
preaches153214893preaches
preacted132710943preacted
preacts113211363pre_acts
preadapted1643733preadapted
preadapts1444003preadapts
preaged11612333pre_aged
prealter1048863prealter
prealters1147773prealters
preamps1336613pre_amps
prearms11369173pre_arms
preaver121011613pre_aver
preavers13910263pre_avers
prebade12310283prebade_
prebake1539093prebake_
prebaked1737173prebaked
precasts1239453precasts
precedes13310713precedes
precipes143212213precipes
precises123218333precises
precited133013813precited
precodes13711573precodes
precures12312903precures
precuts111710473precut_s
predaceous1553943predaceous
predacities1646913predacities
predating13514653predating
predation12313463predation
predations13812153predations
predatisms1545253predatisms
predatory1547713predatory
predawn1335353preda_wn
predeath1447003predeat_h
predebate1446163predebate_
prediabetes1652113prediabetes
predicate14411783predicate_
predicated1649143predicated
predicted1538913predicted
predicts1339623predicts
predigest1357633predigest
predive13511083predive_
predried12309573predried
predusks1543423predusks
preedited1337633preedited
preedits1168763preedit_s
preemies12512193preemies
prees75937173pre___es
prefabs1435163prefa_bs
preface14510923preface_
prefaced1638423prefaced
prefacer1537983prefacer
prefacers1636293prefacers
prefade1339013prefade_
prefaded1537823prefaded
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
pregame1239553pregame_
preheated1539813preheated
preheater1448913preheater
preheaters1557193preheaters
preheats1339423preheat_s
prelacies13310053prelacies
prelatic12311293prelatic
prelatism1347863prelatism
prelatures1245733prelatures
prelives13310383prelives
prelocates1468353prelocates
preludes1137833preludes
premade12311443premade_
prematures1447063prematures
premies113823063pre_mies
premises123018273premises
premixes193110083premixes
prename11412643prename_
prenatal1048373prenatal
prepacks1836583prepacks
prepare111913623prepare_
prepared132210873prepared
preparer12169643preparer
preparers13197673preparers
prepaste12139083prepaste_
prepasted14137673prepasted
prepave14228873prepave_
prepaved16177233prepaved
prepays1437483prepa_ys
preplaces1578753preplaces
preppies1149693preppies
prepubes1436053prepubes
prepuces1438583prepuces
prerace11414123prerace_
presage10312293presage_
presaged1238813presaged
presager1138443presager
presagers1236943presagers
presale9416353presale_
presets94216423preset_s
preshapes1667093preshapes
presides11414913presides
presses93523153pre_sses
prester93519623pre_ster
presters103419003pre_sters
prestos93716093pre_stos
prests84021263pre_st_s
presumes1239843presumes
pretape113511623pretape_
pretaped13339133pretaped
pretaste10139523pretaste_
pretasted12147963pretasted
pretest9517633pre__test
pretties10615133pretties
pretypes15337263pretypes
preunites1138933preunites
prevails1337673prevails
prevalues1445333prevalues
previses133814293previses
prevues1239263pre_vues
prewarms15406733prewarms
prewarns13456943prewarns
prewashes1744753prewashes
prewires133811013prewires
prexes154915953pre__xes
prexies163415003pre_xies
prezes173614693pre__zes
prides94324183prid__es
primages13159273primages
primate111516283primate_
priorates11410763priorates
private121513263private_
privater13158533privater
privatest14196743privatest
probate11414483probate_
probated13410863probated
produces1347903produces
proettes10312763proettes
profanes132311573profanes
prolate9419793prolate_
promotes12314123promotes
pronate9418873pronate_
pronated11414053pronated
propanes122415823propanes
prorate9418733prorate_
prorated11513713prorated
prostates11314423prostates
protases102115033protases
prudes94215443prud__es
pulsates1048813pulsates
pupates113311433p_upates
pyruvates1743143pyruvates
radiates92415303_radiates
rates55352013_r__ates
readies83324713_readies
reales64934123_re_ales
reatas64021023_re_atas
reaves94127573_re_aves
rebate84424113_rebate_
rebated103619703_rebated
rebater93517913_rebater
rebaters103413943_rebaters
rebatos92913133_rebatos
recanes93222263_recanes
recites93524593_recites
recrates102420383_recrates
redacted12410243_redacted
redacts10510943_redacts
redans75421023_reda_ns
reddles93315773_reddles
redes65139133_red__es
redeyes112910973_redeyes
redoes74623773_red_oes
redoxes15310883_redoxes
redries83721713_redries
reduces10513343_reduces
redwares1239053_redwares
redyes104214093_red_yes
refaces123216743_refaces
reflates113115673_reflates
refutes104515733_refutes
regales83520793_regales
regrates92618413_regrates
relaces93420883_relaces
relate64033633_relate_
related83327573_related
relater73723143_relater
relaters83218153_relaters
relaxes143215323_relaxes
remakes134116173_remakes
remate84428683_remate_
remated103522473_remated
remotes94521613_remotes
renames92418053_renames
rentes65431193_re_ntes
repaves123513653_repaves
replates102919283_replates
reputes94615963_reputes
resales74724903_resales
resites74027803_resites
reslates83619513_reslates
restates83423443_restates
retakes113718863_retakes
retapes93917423_retapes
retastes82212903_retastes
retaxes143615093_retaxes
revotes104716403_revotes
rewakes144614983_rewakes
rewaxes173911333_rewaxes
rotates72819773_rotates
sedate73019813_sedate_
sedated93714353_sedated
sedater83713633_sedater
sedatest9249393_sedatest
senates73322613_senates
seriates82620683seriates
serrates82617023serrates
treadles939703treadles
treated83618703tre_ated
treater74219833tre_ater
treaters83615853tre_aters
treaties8316983tre_aties
treats64821703tre_at_s
treddles1036263treddles
updates10329793_updates
uprates93814863upr__ates
urates65027763ur__ates
ureases74416723ure_ases
urinates8314133urinates
wreathes14299893wre_athes
wreaths13338383wre_aths

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.436409841.7
2DLD Change Limit1461624137.90618487.5
3Display Results4134130.1862220.4
 (SQL Overall)1786914138.52820953.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.