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

327 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
percale1131409(None) 
percales12313801percales
cercal10314122cercal_
opercele1244592opercele
opercule1245282opercule
peccable1648122peccable
percaline13410952percaline
persalt9315412persalt
pervade1337022pervade
petrale9312622petrale
presale9416352presale
rescale93215472rescale
aerate64830553aer_ate
aerial64625713aerial_
aerials74017553aerials
arcade91013643_arcade
arcane81216743_arcane
becalm1239203be_calm
became123213163be_came
berake124216083ber_ake
berate84729023ber_ate
bereave1258353bereave
carcase11312733carcase
carpale113414353carpale
cecal94619113ce_cal_
cenacle1139123cenacle
cerate84829463cer_ate
cereal8315833cereal_
cereals9313173cereals
cicale10314503_cicale
circle1039703circ_le
coracle112011723coracle
debacle1237443debacle
decade104216163de_cade
decal85523233de_cal_
decals93717713de_cals
decane93818873de_cane
decare93919153de_care
decile94619213de_cile
deckle1312012453de_ckle
derate74531233der_ate
dermal93614343dermal_
empale102611263_empale
encage93713503_encage
encase83714363_encase
epical10413393epical_
erase54925493_er_ase
ergate7315143_ergate
errable9312183_errable
escape103811663_escape
exhale1636873_exhale
fecal105119213fe_cal_
female11310553fe_male
feral85424653fer_al_
ferals94216643fer_als
feriae95618603feria_e
ferial94621253ferial_
fermate122813003fermate
ferrate103014043ferrate
ferrule1035863ferrule
fertile10311733fertile
ferulae10309603ferulae
ferule93413203fer_ule
freckle16106643freckle
furcate12310453furcate
gearcase1154453gearcase
germane1049663germane
heckle153112093he_ckle
herald10311343her_ald
herbage1337003herbage
herbal112513493herbal_
herbals122710603herbals
hercules1337633hercules
hermae115314473herma_e
keckle11359423ke_ckle
locale83915653_locale
merle75824373mer__le
mescal104113483mescal_
mescals112911553mescals
mezcal19367853mezcal_
mezcals20246533mezcals
miracle1138843miracle
morale85220553mor_ale
nervate1039523nervate
nervule1044943nervule
operable12410323operable
operate9615733oper_ate
operceles1344613operceles
opercula1244993opercula
opercules1345573opercules
oracle84313293_oracle
overcall1337673overcall
overcame151310693overcame
oversale11313873oversale
overscale1447993overscale
pale66055013p___ale
pancake1536673pancake
parable111819773parable
parade94720643par_ade
parae76335703par_a_e
parbake1538353parbake
parcel103915473parcel_
parceled1338333parceled
parcels113712663parcels
parkade1437583parkade
parle75836163par__le
parole84425253par_ole
parral85517533parral_
parrals94414573parrals
parsable12311693parsable
partake1339643partake
pascal10812373pascal_
pascals11610013pascals
peace95026083pe__ace
peaceable1548253peaceable
peage84723563pe__age
peal68648103pe__al_
pealed95322803pe__aled
peals75235493pe__als
pease75231113pe__ase
pebble1238003pe_bble
pecan91919033pe_ca_n
pecans101515833pe_cans
peccant13311733peccant
peccary1636283peccary
peccavi1643093peccavi
pectase112410363pectase
pectate112214693pectate
pedal86022503pe_dal_
pedaled113711883pe_daled
pedaler103410693pe_daler
pedalo93811153pe_dalo
pedals94316033pe_dals
pedate93117763pe_date
peddle103512823pe_ddle
pedicle1238973pedicle
pedocal1237893pedocal_
pedocals1346083pedocals
peelable1238553peelable
peerage1089803peerage
pelage9515363pe_lage
pele65539553pe___le
peltate92013773peltate
penal75228373pe_nal_
pence94924453penc__e
pencel103812913pencel_
pencels113610053pencels
pencil103712973pencil_
penciled1337823penciled
penciler1237113penciler
pencils113011773pencils
penial84120893penial_
penile82219603pe_nile
pennae84314033penna_e
penname11328553penname
pennate93314033pennate
pensile92713543pensile
pentacle1239383pentacle
pentane9415743pentane
penuchle1543763penuchle
penuckle1643263penuckle
peonage1048723peonage
people10310183pe_ople
peptalk1554823peptalk
peracid12312993peracid
percalines1449743percalines
perceive1546973perceive
percent113520603percent
percept133112523percept
perch124518833perc__h
perchance1866393perchance
perched154713233perched
percher143313423percher
perches143717953perches
percoid12312313percoid
percolate13411153percolate
percuss1137163percuss
perdie94718513per_die
perdue93912633per_due
perdure10379623perdure
pere66450263per___e
perea75026443perea__
perfume1446503perfume
perfuse1247663perfuse
pergola1067623pergola
perhaps1446123perhaps
periapt11313413periapt
periblem1445513periblem
pericarp1446123pericarp
pericope1447783pericope
pericycle1843113pericycle
perigee101113383perigee
peril75425953per_il_
periled10316313per_iled
perilla9311223perilla
perilled11410103perilled
perils84121853per_ils
perique1837523perique
perjure16327963perjure
perkily1637803perkily
perlite9317313perlite
permeable1556813permeable
permease1246503permease
permeate12311613permeate
permute1138793permute
peroral9314793peroral_
perorate10417923perorate
perplex1836143per_plex
persalts1038193persalts
perse75429523per__se
persuade1145853persuade
pertain92714963pertain
pertly115312543per_tly
peruke123210393per_uke
perusable1347453perusable
perusal939193perusal_
perusals1047143perusals
peruse84016843per_use
pervaded1535363pervaded
pervader1444863pervader
pervades1437353pervades
pesade9311103pe_sade
pestle83215843pe_stle
petal76526893pe_tal_
petaled103614143pe_taled
petals84719813pe_tals
petiole9311303petiole
petrales10312983petrales
pettable121710713pettable
pettle84116053pe_ttle
phrase11109903phr_ase
pical95524373p_ical_
pickle144215653p_ickle
picrate112014143picrate
pierce104010393pierc__e
pinwale1257843pinwale
pirate82322883pir_ate
placable14169243placable
placate11312433placate
plicae10410953plica_e
plical10411683plical_
plicate11314513plicate
porcine11312843porcine
portable12313203portable
portage103013643portage
portal84218463portal_
portaled11239203portaled
portals94015563portals
prase76128753p_r_ase
prate75135983p_r_ate
prebade12310283prebade
prebake1539093prebake
precast11314853precast
precava1445093precava
precavae1544813precavae
precede1239643precede
precipe133012123precipe
precise113518173precise
precode12311853precode
precure11312553precure
predate10616893predate
preface14510923preface
prefade1339013prefade
prefile123413183prefile
pregame1239553pregame
prelate9519693prelate
premade12311443premade
prename11412643prename
prepare111913623prepare
prepave14228873prepave
prerace11414123prerace
presage10312293presage
presales10315263presales
pretape113511623pretape
prevalue1345073prevalue
prickle153611013prickle
prole74527793p_r_ole
pterylae1343013pterylae
puerile9310093puer_ile
purchase1545293purchase
purfle112511183pur_fle
purple102712673pur_ple
pyrrole1246033pyrrole
rale45050563__r_ale
recall83815723re_call
recane83022873re_cane
recrate92621663recrate
regale74821453re_gale
resale64025543re_sale
rescaled113311303rescaled
rescales103414573rescales
scale74629143__scale
seral56336383ser_al_
serape84818413ser_ape
serfage1138403serfage
serial64625863serial_
serials73919743serials
seriate73722473seriate
serrate73017543serrate
servable13310083servable
serval93913413serval_
servals103410743servals
servile10310643servile
speckle15297553spe_ckle
spiracle1255803spiracle
supermale1349983supermale
supersale11411323supersale
superscale1448003superscale
teacake1335453teacake
terce75721843terc__e
tercel83612993tercel_
tercelet1049883tercelet
tercels94110363tercels
tergal72912833tergal_
ternate7415483ternate
terrace93311843terrace
terrae62915213terra_e
terrane72814233terrane
treacle939973treacle
uppercase1543533uppercase
upscale11136323upscale
verbal112513663verbal_
verbals121910743verbals
verbile1249863verbile
vernacle1345583vernacle
vernal93514213vernal_
versal93013753versal_

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340273278.64315507.0
3Display Results3273270.1063084.9
 (SQL Overall)1786913278.88920102.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.