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

227 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
pectases12241119(None) 
ectases92911671_ectases
pectase112410361pectase_
pectates122213951pectates
deceases11410152deceases
ectasis9249612_ectasis
entases72816272_entases
epitases1038932epitases
hectares1338852hectares
lactases1038522lactases
peases85229472pe__ases
pectate112214692pectate_
pectines121914682pectines
pectizes21229792pectizes
peltasts1035702peltasts
pentanes10316082pentanes
pentoses10312892pentoses
petasos948602pe_tasos
petasus946362pe_tasus
protases102115032protases
spectates13228812spectates
acetates102013063acetates
anatases839793anatases
beclasps1444353beclasps
becurses1236723becurses
betakes134212523be_takes
betises94816123be_tises
cactuses1237933cactuses
cases75048383__c_ases
ceases84427073__ceases
centares102913893centares
centeses1079443centeses
cestuses1038083cestuses
cetanes9315133ce_tanes
chases115128233__chases
crases85532313__crases
cycases1437533cyc_ases
cyclases1537133cyclases
debases103814133de_bases
decades113615513dec_ades
decanes103118913dec_anes
decares102818533dec_ares
decease1049523decease_
deceased1247713deceased
deciares11510633deciares
declares11611313declares
declass1038733declas_s
declasse1165943declasse
declasses1246443declasses
decreases1237223decreases
degases93413103de_gases
dictates11311383dictates
eases56041613_e__ases
ecdyses1333413_ecdyses
ecotages1136973_ecotages
ecstasies1145043_ecstasies
ectypes1434803_ectypes
encases93116053_encases
enchases13310273enchases
entasis73012573_entasis
epistases1146323epistases
epitasis1047433epitasis
erases64425403_e_rases
estates74520183_estates
etapes85415293_e_tapes
euclases1039223euclases
eyases94513683_e_yases
feases95422923fe__ases
fetuses10310243fe_tuses
geotaxes1644743geotaxes
gestates93213733gestates
hectare1238463hectare_
hektares1535813hektares
heptanes1339003heptanes
heptoses1338373heptoses
ictuses938303_ictuses
incases93615973inc_ases
ketoses114912873ke_toses
lactase937963lactase_
lactates10311233lactates
lactoses1039833lactoses
leases65428113le__ases
lectures101310163lectures
maltases1039693maltases
meatuses1038203meatuses
meltages1148243meltages
metages102714973me_tages
metates92720013me_tates
mutases92012043_mutases
necroses10310563necroses
nectaries1149813nectaries
nectars938463necta_rs
nictates1039593nictates
nutcases1085793nutcases
octanes91111393_octanes
octaves12316963_octaves
packages17138733packages
partakes1449923partakes
pases75346503p___ases
pastises103616053pastises
peaces106324083pe__aces
peages94321853pe__ages
pease75231113pe__ase_
peasen84815963pe__asen
pecans101515833pec_a_ns
peccaries1548533peccaries
peccavis1743133peccavis
pechans14810503pecha_ns
pecten102711103pect__en
pectens11189203pect_ens
pectins112315233pect_ins
pectize20259913pectize_
pectized22257593pectized
peculates132112543peculates
peerages1189893peerages
peises84125043pe__ises
pelages10714613pe_lages
pelisses1048483pelisses
peltast9310513peltas_t
peltate92013773peltate_
peltless10267373peltless
peltries10313023peltries
pelvises1337273pelvises
penates93321603pe_nates
penises9318193pe_nises
pennames12287793pennames
pentacles1338773pentacles
pentads1039523penta_ds
pentane9415743pentane_
pentenes10315633pentenes
pentodes11310363pentodes
pentose9311593pentose_
peonages1138473peonages
peploses1269473peploses
pepluses1287023pepluses
peptalks1653843peptalks
peptidases1542983peptidases
peptides132610263peptides
peptizes21269853peptizes
peptones12311033peptones
percales12313803percales
percusses1346503percusses
perfuses1358663perfuses
perhapses1644153perhapses
periapses1346053periapses
permeases1347103permeases
perses85428063pe__rses
pertains102113423pertains
pertness10310093pertness
pertusses1145383pertusses
peruses94018163pe_ruses
pervades1437353pervades
pesades10310903pe_sades
pestles93217693pest_les
petaled103614153pe_taled
petals84719813pe_ta_ls
petards104311153pe_tards
petasoses1145443pe_tasoses
petasuses1144373pe_tasuses
petites93820203pe_tites
petrales10312983petrales
petsais938433pe_tsais
pettles93916483pe_ttles
phases114618403p__hases
phrases12711463p_hrases
phytanes1645763phytanes
pickaxes2344913pickaxes
picrates122013213picrates
pictures1249343pictures
platanes102711883platanes
pleases94515483p_leases
poetises10313953poetises
portages112613223portages
postages112815323postages
potages102416423p_otages
potashes1337833p_otashes
pottages112910453pottages
practises1349623practises
prases84429023p__rases
precasts1239453prec_asts
precesses13310463precesses
precises123218333prec_ises
precreases1445653precreases
pretapes122811533pretapes
pretastes11119423pretastes
protasis102411973protasis
proteases112110833proteases
ptoses83514673p__toses
purchases1645633purchases
pycnoses1554973pycnoses
recanes93222263rec_anes
recasts93413533rec_asts
recesses10312323recesses
reclames12310893reclames
reclasps1235053reclasps
recluses105111733recluses
recrates102420373recrates
recuses94619463rec_uses
reductases1344283reductases
releases8313343releases
rennases848983rennases
restages92815773restages
restates83423433restates
retakes113718863re_takes
retapes93917423re_tapes
retastes82212903re_tastes
retaxes143615093re_taxes
rictuses1037563rictuses
sectaries11312243sectaries
septages1168263septages
speciates13229233speciates
spectacles1643913spectacles
spectate12248833spectate_
spectated14236593spectated
spectres12268683spect_res
stases64225563__stases
sucrases10310253sucrases
teases65426273te__ases
tectites1039993tectites
teniases838623teniases
tentages91011043tentages
terrases82111483terrases
testates83615453testates
texases1437573te_xases
typecases1643853typec_ases
uncases93516553unc_ases
ventages12119773ventages

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.406440125.6
2DLD Change Limit1461622277.76618820.8
3Display Results2272270.0762986.8
 (SQL Overall)1786912278.24821664.8
 
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.