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

230 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
placates1231175(None) 
placate11312431placate_
placated1338451placated
placater1238011placater
placaters1336471placaters
glaciates1267342glaciates
lactates10311222_lactates
locates93218812_locates
palates93624932p_alates
palpates122613062palpates
placards1345812placards
places104323702plac__es
placets113911222placet_s
plackets1646582plackets
planate9314572planate_
platanes102711882platanes
plates85432242pl__ates
playdates1554902playdates
playmates1646602playmates
plicate11314512plicate_
plicated13310642plicated
vacates12312832_vacates
abates85825033__abates
acutes83917723__acutes
agates76121343__agates
aguacates1244583aguacates
alates64833963__alates
alcades101011473al_cades
allocates11410473allocates
calcites12313003calcites
carates95630613_carates
cates75951893___cates
clavate1238713clavate_
climates12311973climates
colocates13312853colocates
cyanates13238433cyanates
dacites101114593_dacites
dealates92716683dealates
delicates12314313delicates
duplicates1546633duplicates
educates1139623educates
elates65032363el__ates
elevates111110423elevates
eluates72014683el_uates
emaciates1347883emaciates
emanates10311333emanates
evacuates14256803evacuates
explicates2196663explicates
facades1339033_facades
falcate12311613falcate_
falcated1438473falcated
flatmates1446193flatmates
fracases1336993fracases
furcates1339883furcates
gallates92815523gallates
glaces94218023glac__es
glaciate1168073glaciate_
glaciated1365753glaciated
glacises1138503glacises
gradates10510783gradates
hamates122917683_hamates
imamates1237663imamates
implicates1646783implicates
jacales16310323_jacales
karates115617473_karates
khanates1535733khanates
labiates101011513_labiates
lacerates112413773_lacerates
laces76141763_lac__es
laches116528343_lac_hes
lactams1136953_lactams
lactase937953_lactase
lactases1038513_lactases
lactate9312693_lactate_
lactated1138863_lactated
lacunes9159623_lacunes
lanate6421263_lanate_
lanated8313203_lanated
lattes65324203_la_ttes
lavages1138603_lavages
leachates1446663leachates
legates82917683_legates
ligates82318383_ligates
locales93715093_locales
locate83919843_locate_
located103114183_located
locater93113603_locater
locaters102710073_locaters
lucites9311863_lucites
luxates1436973_luxates
lysates10317473_lysates
malates93522603_malates
maleates103316343maleates
oleates7417833ol_eates
oxalates1557063oxalates
pacas96029403p_aca__s
paces96741113p_ac__es
packages17138733p_ackages
packets155114773p_ackets
pacts95125803p_ac_t_s
palaces114216453p_alaces
palate84226783p_alate_
paleate94120003paleate_
palettes103112833palettes
palliates11311033palliates
palmate113215233palmate_
palmated132511003palmated
palpate113213923palpate_
palpated13249763palpated
pancakes1637073pancakes
parades104121463p_arades
pastes85233913p_a_stes
pates76047893p___ates
pavanes123612653p_avanes
peaces106324083peac__es
peaches144120053peac_hes
peacoats1247833peacoat_s
pectates122213953pectates
penates93321593p_enates
percales12313803percales
phenates13611573phenates
phonates13410643phonates
phorates13413043phorates
picrates122013213picrates
pirates93020333p_irates
placable14169243placable
placably17156673placably
placard1236783placa_rd
placarded1543253placarded
placating1438513placating
placation1339773placation
placations1438583placations
placative1646223placative
placatory1645713placatory
place94824613plac__e_
placeboes1543563placeboes
placebos1443713placebos
placed114318003plac__ed
placeless1335613placeless
placemen1445783placemen
placentas1364823placentas
placer105117743plac__er
placers114515263plac_ers
placet103923673plac__et
placket15412873plac_ket
placks144414153plac__ks
placoids1347343placoids
plages94520153pl__ages
plagues103311063pla_gues
plaices11411143pla_ices
plaints94012053plaint_s
plaister1068013plaister
plaisters1137813plaisters
plaited103713893pla_ited
plaiter93615393pla_iter
plaiters103512633pla_iters
plaits83816473pla_it_s
planches153111863planches
planchets16236743planchets
planes85028083pl__anes
planets93914083planet_s
plankter1435363plankter
plankters1544583plankters
planted103516123pla_nted
planter94017803pla_nter
planters102915323pla_nters
plants84921803pla_nt_s
plaques18317893pla_ques
plashes124417393pla_shes
plaster93318693pla_ster
plasters103518133pla_sters
platane93112303platane_
platans93413123plata_ns
plate74635113pl__ate_
plated95225773pl__ated
platen84518203pl__aten
platens94213983pl__atens
plater84427693pl__ater
platers93924093pl__aters
platies93722543pla_ties
plats75531373pl__at_s
platted103614263pla_tted
platter93917413pla_tter
platters103415283pla_tters
platys11459853pl__atys
playacted1742643playacted
playacts1543813playacts
playas114612283playa__s
playdate1465263playdate_
playlets1334903playlets
playmate1566463playmate_
plazas17409913plaza__s
pleaches153210433pleac_hes
pleases94515483pl_eases
pleated103816633pl_eated
pleater93916333pl_eater
pleaters103613793pl_eaters
pleats85218593pl_eat_s
pleiades1145753pleiades
plicae10410953plica_e_
plicately1644563plicately
plicatures1443983plicatures
plumages1335653plumages
plumate1149803plumate_
poaches144416943poac_hes
polecats1248833polecat_s
prates84633163p__rates
predates11615813predates
prelates10418573prelates
prelocates1468353prelocates
primates121515933primates
privates131812373privates
probates12414283probates
pronates10418373pronates
prorates10418073prorates
pulsates1048813pulsates
pupates113311433p_upates
relocates11712933relocates
replicates1449453replicates
savates10312953_savates
silicates11311523silicates
slates64934063sl__ates
stactes91914633stac_tes
teacakes1435883teacakes
tractates1159763tractates
ululates848433ululates
vacate11314553_vacate_
vacated1349353_vacated
valuates112811203valuates
zincates1937743zincates

Search took 10 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 Limit1461622309.26315779.1
3Display Results2302300.0962395.8
 (SQL Overall)1786912309.51518779.9
 
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.