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

286 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
pectates12221395(None) 
pectases122411191pectases
pectate112214691pectate_
spectates13228811spectates
acetates102013062acetates
dictates11311382dictates
ectases92911672_ectases
estates74520182_estates
gestates93213732gestates
hectares1338852hectares
lactates10311222lactates
metates92720012me_tates
nictates1039592nictates
pectase112410362pectase_
pectines121914682pectines
pectizes21229782pectizes
peculates132112542peculates
peltate92013772peltate_
penates93321592pe_nates
pentanes10316082pentanes
petites93820202pe_tites
picrates122013212picrates
recrates102420372recrates
restates83423432restates
speciates13229232speciates
spectate12248832spectate_
spectated14236592spectated
tectites1039992tectites
testates83615452testates
acetate92514753acetate_
acetated112010683acetated
actuates10310313_actuates
aerates74627493ae_rates
agitates9310883agitates
apostates1149163apostates
bedmates1349183bedmates
berates94126873be_rates
betakes134212523be_takes
cates75951893__c_ates
centares102913893centares
cerates95428253ce_rates
cetanes9315133ce_tanes
crates85736063__crates
dealates92716683dealates
debates103718533de_bates
decades113615513dec_ades
decanes103118913dec_anes
decares102818533dec_ares
deceases11410153deceases
deciares11510633deciares
decimates14410693decimates
declares11611313declares
decorates12314743decorates
deflates123013943deflates
delates83526283de_lates
delectates1348193delectates
dentate8315153dentate_
dentated10411703dentated
derates84028893de_rates
deviates12312733deviates
dictate10311663dictate_
dictated1239203dictated
ecartes94212563_ecartes
eclats8313033_eclat_s
ecotages1136973_ecotages
ectasis9249613_ectasis
ectatic11310123_ectatic
ectypes1434803_ectypes
edentates1046953edentates
elates65032363_e_lates
eluates72014683_eluates
enates64026423_e_nates
entases72816273_entases
epilates10313503epilates
epitases1038933epitases
equates162012323_equates
ergates8314493_ergates
eructates1146953eructates
estate64719763_estate_
estated83715573_estated
etapes85415293_e_tapes
execrates1839563execrates
fellates11312753fellates
ferrates113013423ferrates
gelates83219583ge_lates
gemmates13307673gemmates
geotaxes1644743geotaxes
gestate83614073gestate_
gestated102910573gestated
hebetates1446433hebetates
hectare1238463hectare_
hektares1535813hektares
heptanes1339003heptanes
hesitates1269793hesitates
imitates10310503imitates
instates81615833instates
lactases1038513lactases
lactate9312693lactate_
lactated1138863lactated
leachates1446663leachates
lectures101310153lectures
legates82917683le_gates
levitates1247863levitates
locates93218813loc_ates
mediates112814063mediates
meditates1239813meditates
meltages1148243meltages
metages102714973me_tages
metate82720533me_tate_
mutates92215793_mutates
nectaries1149813nectaries
nectars938463necta_rs
negates83215843ne_gates
neonates8310063neonates
nictate9310223nictate_
nictated1137793nictated
notates72817483_notates
nutates73214973_nutates
octanes91111393_octanes
octaves12316963_octaves
operates10515413ope_rates
packages17138733packages
palates93624933p_alates
palpates122613063palpates
partakes1449923partakes
pates76047893p___ates
peaces106324083pe__aces
peacoats1247833peacoat_s
peages94321843pe__ages
peases85229473pe__ases
peats76140193pe__at_s
pecans101515833pec_a_ns
peccaries1548533peccaries
peccavis1743133peccavis
pechans14810503pecha_ns
pecten102711103pec__ten
pectens11189203pect_ens
pectinate1349553pectinate_
pectins112315233pect_ins
pectize20259913pectize_
pectized22257593pectized
peculate122414663peculate_
peculated142310843peculated
pedate93117763pe_date_
peerages1189893peerages
pelages10714613pe_lages
pelites93821993pe_lites
peltasts1035703peltasts
peltately1443953peltately
peltries10313023peltries
penetrates1248723penetrates
penlites10312273penlites
pennames12287793pennames
pennate93314033pennate_
pennated11299543pennated
pentacles1338773pentacles
pentads1039523penta_ds
pentane9415743pentane_
pentenes10315633pentenes
pentodes11310363pentodes
pentoses10312893pentoses
peonages1138473peonages
peptalks1653843peptalks
peptides132610263peptides
peptizes21269853peptizes
peptones12311033peptones
percales12313803percales
percolates14410413percolates
perlites10316353perlites
permeates13311773permeates
permutes1238713permutes
perorates11417023perorates
pertains102113423pertains
pervades1437353pervades
pesades10310903pe_sades
pestles93217693pest_les
petabytes1642793pe_tabytes
petaled103614143pe_taled
petals84719813pe_ta_ls
petards104311153pe_tards
petasos948603pe_tasos
petasus946363pe_tasus
petite84320653pe_tite_
petrales10312983petrales
petted94121523pe_t_ted
petter83924773pe_t_ter
petters93722363pe_t_ters
pettitoes1144183pettitoes
pettles93916483pe_ttles
peyotes1238483pe_yotes
phenates13611573phenates
phonates13410643phonates
phorates13413043phorates
phytanes1645763phytanes
pickaxes2344913pickaxes
picrate112014143picrate_
picrated132110113picrated
picrites121811083picrites
pictures1249343pictures
pirates93020333p_irates
placates12311753placates
platanes102711883platanes
plates85432243p__lates
portages112613223portages
postages112815323postages
postdates1248863postdates
potages102416423p_otages
potatoes1039943p_otatoes
potentates12106333potentates
pottages112910453pottages
prates84633163p__rates
predates11615813predates
prelates10418573prelates
pretapes122811533pretapes
pretastes11119423pretastes
primates121515933primates
privates131812373privates
probates12414283probates
pronates10418373pronates
prorates10418073prorates
prostates11314423prostates
protases102115033protases
pulsates1048813pulsates
punctate1246473punctate_
punctated1445053punctated
punctuates1443453punctuates
pupates113311433p_upates
rebates95123183re_bates
recanes93222263rec_anes
recites93524583rec_ites
reclames12310893reclames
recoated113416783recoated
recoats92616643recoat_s
recrate92621663recrate_
recrated112918603recrated
recreates11313363recreates
rectorates12410363rectorates
redates83423873re_dates
redictates1348233redictates
reflates113115663reflates
regrates92618403regrates
relates73731433re_lates
reluctates1246703reluctates
remates93827113re_mates
replates102919273replates
reslates83619503reslates
restages92815773restages
restate73824883restate_
restated93120183restated
retakes113718863re_takes
retapes93917423re_tapes
retastes82212903re_tastes
retaxes143615093re_taxes
rotates72819773_rotates
seatmates1157823seatmates
secretes10410473secretes
sectaries11312243sectaries
sedates83418033se_dates
senates73322583se_nates
sensates8511133sensates
septages1168263septages
septate9511873septate_
seriates82620673seriates
serrates82617023serrates
smectites1344623smectites
speciate12209583speciate_
speciated14207543speciated
spectacles1643913spectacles
spectator1344833spectator
spectators1444533spectators
spectres12268683spect_res
speculates14237903speculates
states64337083__states
tates55444983___tates
tectite9310583tectite_
tektites1236613tektites
tentages91011043tentages
testate73916233testate_
tractates1159763tractates
uncrates10314563uncrates
unstates81314993unstates
upstates10189643upstates
vacates12312833vac_ates
vegetates1346403vegetates
ventages12119773ventages
veritates12310973veritates

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.1561145455.1
2DLD Change Limit1461622867.51619446.8
3Display Results2862860.1102600.0
 (SQL Overall)1786912867.78222962.1
 
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.