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

261 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
pectase11241036(None) 
pectases122411191pectases
pectate112214691pectate
decease1049522decease
ectases92911672_ectases
hectare1238462hectare
lactase937952lactase
pease75231112pe__ase
pectates122213952pectates
pectize20259912pectize
peltast9310512peltast
peltate92013772peltate
pentane9415742pentane
pentose9311592pentose
spectate12248832spectate
acetate92514753acetate
acetose938843acetose
anatase738943anatase
became123213163bec_ame
because1136233because
beclasp1335263beclasp
becurse1136183becurse
betake124512703be_take
betas75528763be_tas_
betise85616273be_tise
bettas84913923bettas_
case65848083__c_ase
cease75227653__cease
centare93113703centare
centas85020703centas_
cestas85018543cestas_
cetane8315283ce_tane
chase105127123__chase
cyclase1436613cyclase
debase94014473de_base
decade104216163dec_ade
decane93818873dec_ane
decare93919153dec_are
deceased1247713deceased
deceases11410153deceases
deciare10710663deciare
declare10411223declare
declass1038733declass
declasse1165943declasse
decrease1136563decrease
deltas74414823deltas_
dentate8315153dentate
dictate10311663dictate
ease45042333_e__ase
ecotage1036883_ecotage
ecstasy1252603_ecstasy
ectasis9249613_ectasis
ectype1334283_ectype
encase83714363_encase
enchase1239453enchase
entases72816273_entases
epitases1038933epitases
erase54925493_e_rase
estate64719763_estate
etape74413703_e_tape
etas46432273_e_tas_
euclase938933euclase
fease84824873fe__ase
fetas85624403fe_tas_
gestate83614073gestate
getas65421483ge_tas_
hectares1338853hectares
hektare1435503hektare
heptane1238363heptane
heptose1237493heptose
incase83615283inc_ase
ketose105711813ke_tose
lactases1038513lactases
lactate9312693lactate
lactose969473lactose
lease55230263le__ase
lecture9149513lecture
maltase938903maltase
meccas1239493meccas_
meltage1037953meltage
metage93114453me_tage
metate82720533me_tate
mutase82811983_mutase
necrose939723necrose
nectar838853necta_r
nectars938463nectars
nectary1246223nectary
nictate9310223nictate
nutcase975763nutcase
octane81411633_octane
octave11157343_octave
pacas96029403pac_as_
pachas135017143pachas_
package16128013package
pacts95125803pact_s_
partake1339643partake
pase65346863p___ase
pastas85422873pastas_
peace95026083pe__ace
peage84723563pe__age
peas65755063pe__as_
peasen84815963pe__asen
peases85229473pe__ases
peats76140193peat_s_
pecan91919033pec_a_n
pecans101515833pec_ans
peccable1648123peccable
peccant13311733peccant
peccary1636283peccary
peccavi1643093peccavi
pechan13511543pecha_n
pechans14810503pechans
pechs125516203pec_hs_
peckish18227293peckish
pecks135724433pec_ks_
pecs84634103pec__s_
pecten102711103pect_en
pectens11189203pectens
pectic122913873pect_ic
pectin102615533pect_in
pectinate1349553pectinate
pectines121914683pectines
pectins112315233pectins
pectized22257593pectized
pectizes21229783pectizes
peculate122414663peculate
pedate93117763pe_date
peerage1089803peerage
peise75825773pe__ise
pelage9515363pe_lage
pelisse967063pelisse
pelotas9410723pelotas_
peltasts1035703peltasts
pelts76128813pelt_s_
penates93321593penates
pennae84314033penna_e
penname11328553penname
pennate93314033pennate
pentacle1239383pentacle
pentad9313763penta_d
pentads1039523pentads
pentanes10316083pentanes
pentene9313793pentene
pentode1039893pentode
pentoses10312893pentoses
peonage1048723peonage
peptalk1554823peptalk
peptidase1442783peptidase
peptide122910683peptide
peptize20279483peptize
peptone11310763peptone
percale11314093percale
perfuse1247663perfuse
permease1246503permease
perse75429523pe__rse
pertain92714963pertain
pertest9317043pertest
peruse84016843pe_ruse
pervade1337023pervade
pesade9311103pe_sade
pesetas938753pesetas_
pestle83215843pest_le
pestles93217693pestles
pestos84719083pestos_
pests75933273pest_s_
petal76526893pe_ta_l
petaled103614143pe_taled
petals84719813pe_tals
petard95013803pe_tard
petasos948603pe_tasos
petasus946363pe_tasus
petite84320653pe_tite
petrale9312623petrale
pets66248333pe_t_s_
petsai838083pe_tsai
pettable121710713pettable
pettish1238283pettish
pettle84116053pe_ttle
pettles93916483pettles
phase104617213p__hase
phrase11109903p_hrase
phytane1545443phytane
picas94626523pic_as_
pickaxe2244623pickaxe
picrate112014143picrate
picture1158613picture
pietas84516503pietas_
pintas85021393pintas_
pitas77427673p_itas_
pittas86014523pittas_
platane93112303platane
please84315733p_lease
poetise9314043poetise
portage103013643portage
postage103214853postage
postbase1246443postbase
potage92715903p_otage
potash1138273p_otash
pottage103310603pottage
practise12310143practise
prase76128753p__rase
precast11314853prec_ast
prechose15129773prechose
precise113518173prec_ise
precrash1544823precrash
precrease1345233precrease
pretape113511623pretape
pretaste10139523pretaste
protases102115033protases
protease10209893protease
punctate1246473punctate
purchase1545293purchase
reatas64021013reatas_
recane83022873rec_ane
recast83422773rec_ast
rechose121312043rechose
reclame11411063reclame
reclasp1136643reclasp
recluse95210773recluse
recrate92621663recrate
recta74220263recta__
rectal84418133recta_l
rectos85718783rectos_
rectus83314633rectus_
recuse85519163rec_use
reductase1244553reductase
release7312763release
rennase738713rennase
restage83316193restage
restate73824883restate
retake104718533re_take
retape83917683re_tape
retaste72313133re_taste
retuse66617223re_tuse
sectary1238273sectary
sectile9311973sectile
sects75622893sect_s_
septage1078403septage
septate9511873septate
setae56026223se_ta_e
setose65114773se_tose
speciate12209583speciate
spectacle1544083spectacle
spectated14236593spectated
spectates13228813spectates
spectre11297773spect_re
spectres12268683spectres
sucrase9310343sucrase
tease55428713te__ase
tecta74215523tecta__
tectal83713253tecta_l
tectite9310583tectite
tentage81010643tentage
testae64216253testa_e
testate73916233testate
typecase1543463typec_ase
uncase83817433unc_ase
ventage11109623ventage
vestas95916683vestas_
yentas94614213yentas_
zetas145018163ze_tas_

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272616.20321606.8
3Display Results2612610.0932806.5
 (SQL Overall)1786912616.45227695.4
 
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.