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

268 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
placate1131243(None) 
placated1338451placated
placater1238011placater
placates12311751placates
planate9314571planate
plicate11314511plicate
clavate1238712clavate
falcate12311612falcate
glaciate1168072glaciate
lactate9312692_lactate
lanate6421262_lanate
locate83919842_locate
palate84226782p_alate
paleate94120002paleate
palmate113215222palmate
palpate113213922palpate
placable14169242placable
placard1236782placard
placaters1336462placaters
placative1646222placative
place94824612plac__e
placet103923672placet_
placets113911222placets
placket15412872placket
platane93112302platane
plate74635112pl__ate
playdate1465262playdate
playmate1566462playmate
plicae10410952plica_e
plicated13310642plicated
plumate1149802plumate
vacate11314552_vacate
abate76627843__abate
acuate8315633__acuate
acute74720363__acute
agate66525143__agate
aguacate1144963aguacate
alate55340323__alate
alcade91111513al_cade
allocate10411013allocate
baccate131011263baccate
blate75933783bl__ate
calceate1239863calceate
calcite11413783calcite
calycate1537893calycate
carate84734003_carate
cate66254593___cate
climate11312833climate
cloacae1145233cloaca_e
colocate12313433colocate
cyanate12259703cyanate
dacite91115883_dacite
dealate83617843dealate
delicate11315493delicate
dilatate947773dilatate
duplicate1447003duplicate
educate10310213educate
elate55335883el__ate
elevate101110373elevate
eluate62315433el_uate
emaciate1248753emaciate
emanate9312473emanate
evacuate13217303evacuate
explicate20117493explicate
facade1238803_facade
facete115014833_facete
falcated1438473falcated
flatmate1346393flatmate
furcate12310453furcate
galeate83916773galeate
gallate83417113gallate
glabrate1146033glabrate
glace87420153glac__e
glaciated1365753glaciated
glaciates1267343glaciates
gladiate1057053gladiate
globate1057813globate
gradate9511213gradate
hamate113319823_hamate
imamate1138093imamate
implicate1547273implicate
karate105320923_karate
khanate1437073khanate
labiate91313573_labiate
lace66848473_lac__e
lacerate102214703_lacerate
lactam10310943_lactam
lactase937953_lactase
lactated1138863_lactated
lactates10311223_lactates
lacunate10128963_lacunate
lacune8169673_lacune
lanated8313203_lanated
late47560483_l__ate
latte55426303_la_tte
lavage1038263_lavage
leachate1347443leachate
legate72917453_legate
ligate72519243_ligate
lobate82915243_lobate
locale83915653_locale
located103114183_located
locater93113603_locater
locates93218813_locates
lucite8313343_lucite
lunate6316043_lunate
luxate1338083_luxate
lyrate94112103_lyrate
lysate9388103_lysate
malate84624553_malate
maleate94117543maleate
oleate6318883ol_eate
oxalate1457623oxalate
paca85132243p_aca__
pacas96029403p_aca_s
pace86345773p_ac__e
package16128013p_ackage
packet144726503p_acket
pact86648723p_ac_t_
pacts95125803p_ac_ts
palace104516913p_alace
palates93624933p_alates
paleae84820293palea_e
palette93613983palette
palliate10311893palliate
palmated132511003palmated
palpated13249763palpated
palpates122613063palpates
pancake1536673pancake
parade94720643p_arade
parae76335703p_ara_e
paste74932953p_a_ste
pate65350463p___ate
pavane114113443p_avane
peace95026083peac__e
peacoat11412913peacoat_
peacoats1247833peacoats
pectate112214693pectate
pedate93117763p_edate
peltate92013773peltate
pennate93314033pennate
percale11314083percale
phenate12412193phenate
phonate12411813phonate
phorate12413363phorate
picante11310523picante
piccata1345703piccata
picrate112014143picrate
pileate93815923pileate
pinnate93613743pinnate
pirate82322883p_irate
placably17156673placably
placarded1543253placarded
placards1345813placards
placating1438513placating
placation1339773placation
placatory1645713placatory
placeable1536913placeable
placebo1343293placebo
placed114318003plac_ed
placemen1445783placemen
placenta1275723placenta
placentae1364353placentae
placer105117743plac_er
placers114515263placers
places104323703plac_es
placid114012543plac_id
placing123815283placing
plack135017843plac__k
plackets1646583plackets
placks144414153plac_ks
placoid1239763placoid
plagal948573plaga_l
plage84520403pl__age
plague93610853pla_gue
plaice10311553pla_ice
plaint85323203plaint_
plaints94012053plaints
plaister1068013plaister
plait75631573pla_it_
plaited103713893pla_ited
plaiter93615393pla_iter
plaits83816473pla_its
planar84212713plana_r
planche14299753planche
planchet152511963planchet
plane74929143pl__ane
planet84228353planet_
planets93914083planets
plankter1435363plankter
plant75437113pla_nt_
plantar9369993plantar
planted103516123pla_nted
planter94017803pla_nter
plants84921803pla_nts
planulate1146893planulate
plaque17317643pla_que
plaster93318693pla_ster
plat66048873pl__at_
platan83913693plata_n
platanes102711883platanes
platans93413123platans
plated95225773pl__ated
platen84518203pl__aten
plater84427693pl__ater
plates85432243pl__ates
plats75531373pl__ats
platted103614263pla_tted
platter93917413pla_tter
platy105021663pl__aty
playa105812943playa__
playable15137923playable
playact1446553playact
playacted1742643playacted
playacts1543813playacts
playas114612283playa_s
playdates1554903playdates
playlet1239523playlet
playmates1646603playmates
plaza164311063plaza__
plazas17409913plaza_s
please84315733pl_ease
pleat74734473pl_eat_
pleated103816633pl_eated
pleater93916333pl_eater
pleats85218593pl_eats
plica9613373plica__
plical10411683plica_l
plicately1644563plicately
plicature1344023plicature
plumage1245503plumage
polecat11313143polecat_
polecats1248833polecats
prate75135983p__rate
predate10616893predate
prelate9519693prelate
prelocate13109503prelocate
primate111516283primate
private121513263private
probate11414483probate
prolate9419793prolate
pronate9418873pronate
prorate9418733prorate
pulsate9510233pulsate
punctate1246473punctate
pupate104213123p_upate
ramate83921673_ramate
relocate10713523relocate
replicate13410043replicate
saccate111311763saccate
savate9313783_savate
silicate10312623silicate
slainte738543slainte
slate55438283sl__ate
spicate113214193spicate
stacte82113913stac_te
sulcate9314423sulcate
teacake1335453teacake
thecate123210023thecate
toccate1138773toccate
tractate10411003tractate
ululate749963ululate
vacated1349353_vacated
vacates12312833_vacates
vallate103016563vallate
valuate102512733valuate
valvate133710813valvate
zincate1838533zincate

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.1401276364.3
2DLD Change Limit1340272686.01622278.4
3Display Results2682680.0932881.7
 (SQL Overall)1786912686.24928595.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.