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

232 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
palmated13251100(None) 
palmate113215231palmate_
palpated13249761palpated
alated75625142_al_ated
falcated1438472falcated
galeated104111572galeated
palaced124110772pal_aced
palate84226782pal_ate_
palates93624932pal_ates
paleate94120002paleate_
palleted1139862palleted
palliated1238492palliated
palmately1644442palmately
palmed114314642palm__ed
palpate113213922palpate_
palpates122613062palpates
pileated112711132pileated
placated1338452placated
plated95225772p_l_ated
pleated103816632p_leated
pulsated1136852pulsated
valuated12239202valuated
abated95918453_a_bated
ablated102513443_ablated
aerated85322373_aerated
alate55340323_al_ate_
alates64833963_al_ates
alerted82512223_alerted
allayed11138063_allayed
amazed18519313_a_mazed
animated111612373animated
ansated84214003_ansated
aurated83817793_aurated
aviated11310263_aviated
baccated15148373baccated
baldpated1543823baldpated
ballasted1245453ballasted
balloted1189043balloted
balsamed1344543balsamed
belated103520013bel_ated
bleated104015973_bleated
bloated104513433_bloated
bromated1339173bromated
calmed114816383calm__ed
caseated11310713caseated
casemated1446953casemated
caudated1238063caudated
caveated1439133caveated
ciliated11510953ciliated
cleated103417843_cleated
collated113615063collated
cremated133412963cremated
dalmatic1348683dalmatic
damaged1257453da_maged
dealated103213603deal_ated
delated93722873del_ated
dilated93115823dil_ated
elated74725823_el_ated
epilated11310753epil_ated
evaluated13276653evaluated
falcate12311613falcate_
fellated1239563fellated
filiated12610083filiated
floated113312703_floated
foliated1249913foliated
galatea839953gal_atea
galeate83916783galeate_
gallanted1145893gallanted
gallate83417123gallate_
gallates92815523gallates
galleted1038213galleted
gelated93615633gel_ated
gemmated14336293gemmated
gloated93511533_gloated
halted105019603hal__ted
hamate113319833ha_mate_
hamates122917683ha_mates
helmeted1435833helmeted
labiated11109303labiated
lactated1138863lactated
lanated8313203la_nated
lariated91212063lariated
lated65240673__l_ated
malate84624553mal_ate_
malates93522603mal_ates
maleate94117543maleate_
maleates103316343maleates
malted94819863mal__ted
mammate104411273mammate_
mandated12310293mandated
mated85537783___mated
mismated131111333mismated
narrated9310323narrated
oxalated1695323oxal_ated
packaged18115753packaged
packeted17148283packeted
paginated13309463paginated
painted104214633pa_inted
pajamaed2042623pajamaed
palace104516913pal_ace_
palaces114216453pal_aces
palatal9310153pal_atal
palaver1238753pal_aver
paleae84820293palea_e_
paled85538723pal___ed
palette93613983palette_
palettes103112833palettes
palisaded1343563palisaded
palled94625163pal__led
palliate10311893palliate_
palliates11311033palliates
palmar104113463palma__r
palmary14338553palma_ry
palmation13310223palmation
palmer105816543palm__er
palmette1247733palmette
palmettes1346883palmettes
palmetto1244983palmetto
palmier113312173palm_ier
palmister1345053palmister
palmitate1346413palmitate_
palmitates1445453palmitates
palmitin1248053palmitin
palmtop1343873palm_top
palpator1247123palpator
palped114513643pal__ped
palpitated1544233palpitated
palsied102911303pal_sied
palter84423263pal__ter
paltered113012483paltered
pancaked1734893pancaked
panted95024823pa__nted
paraded114014263pa_raded
parbaked1735503parbaked
parented11912213parented
pargeted1238673pargeted
parlayed1435813parlayed
parroted1158843parroted
parted94228683pa__rted
passaged1236243passaged
pasted94426903pa__sted
pated85237843p___ated
patented1188893patented
patinated123911413patinated
patriated1238533patriated
patted94724683pa__tted
paymaster1643873paymaster
pelleted1138193pelleted
peltate92013773peltate_
pelted94617753pel__ted
pennated11299543pennated
permeated1439363permeated
permuted1336703permuted
phonated1447893phonated
picrated132110113picrated
pileate93815923pileate_
pillaged12298093pillaged
pillared11228093pillared
piloted10310323pil_oted
pinnated11338553pinnated
pirated102515613p_irated
placate11312433placate_
placater1238013placater
placates12311753placates
placed114318003p_l_aced
plaited103713893p_laited
planate9314573planate_
planed94420913p_l_aned
planted103516123p_lanted
plate74635113p_l_ate_
platen84518203p_l_aten
plater84427693p_l_ater
plates85432243p_l_ates
platted103614263p_latted
playacted1742643playacted
played124815033p_l_ayed
playmate1566463playmate_
playmates1646603playmates
pleaded113511263p_leaded
pleased103712073p_leased
pleater93916333p_leater
plicated13310643plicated
plotted104612373p_lotted
plumaged1443573plumaged
plumate1149803plumate_
poleaxed1854813poleaxed
polkaed1435323polka_ed
polluted1135433polluted
pomaded13377863p_omaded
prated94924923p__rated
predated12513273predated
primate111516283primate_
primates121515933primates
probated13410863probated
promoted13310543promoted
prompted1536903prompted
pronated11414053pronated
prorated11513713prorated
psalmed1234503psalm__ed
pulsate9510233pulsate_
pulsates1048813pulsates
pupated12319353p_upated
radiated102512593radiated
ramate83921683ra_mate_
related83327573rel_ated
remated103522473_remated
salaamed1134623salaamed
salivated1337473salivated
salted74121203sal__ted
saluted84511713sal_uted
salvaged1335363salvaged
satiated9311603satiated
slated75028313_sl_ated
solated83618023sol_ated
solvated12237443solvated
spoliated1246913spoliated
stalemated1344323stalemated
sulcated11310373sulcated
sulfated1238833sulfated
summated13298833summated
tailgated1145133tailgated
talented938423talented
tallaged10257923tallaged
unmated103317023_unmated
vacated1349353va_cated
valeted1139013val_eted
validated1446493validated
vallate103016563vallate_
valuate102512733valuate_
valuates112811203valuates
valvate133710813valvate_
variated121211393variated

Search took 8 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.1731032896.0
2DLD Change Limit1461622326.76621602.4
3Display Results2322320.0932494.6
 (SQL Overall)1786912327.03225411.1
 
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.