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

231 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
palettes10311283(None) 
galettes93111151galettes
palette93613981palette_
pallettes1148801pallettes
palmettes1346881palmettes
calottes10610082calottes
casettes1039652casettes
epaulettes1242412epaulettes
galette84212692galette_
gazettes18296862gazettes
layettes1136262layettes
maleates103316342maleates
navettes1136612navettes
paillettes1244652paillettes
palates93624932pal_ates
paleate94120002paleate_
paletots1047802paletots
palets85122312pale_t_s
pallette1039512pallette_
palmette1247732palmette_
palmettoes1442972palmettoes
palmettos1343702palmettos
palpates122613062palpates
parkettes15137592parkettes
pipettes1237562pipettes
proettes10312762proettes
raclettes1147012raclettes
abetted1058323_abetted
abetter958323_abetter
abetters1057173_abetters
acetates102013063_acetates
alates64833963_al_ates
albites9313203_albites
alerted82512223_alerted
alerter72111513_alerter
alertest8310173_alertest
alerts64418223_alert_s
aplites9314933apl_ites
appetites1347513appetites
aretes64425353_are_tes
ariettes8411353ariettes
baguettes12115393baguettes
ballutes1037523ballutes
barbettes1348163barbettes
barrettes1149063barrettes
boletes9316063bole_tes
burettes1048943burettes
calcites12313003calcites
caleches15269933caleches
calotte9510563calotte_
caseates10313703caseates
casette9310393casette_
cassettes1146703cassettes
cavettos1344973cavettos
celestes10310013celestes
culottes1076293culottes
curettes1039313curettes
cuvettes1335323cuvettes
daleths1135323dale_ths
deletes83117933dele_tes
dinettes9310193dinettes
epaulette1142783epaulette_
epauletted1341653epauletted
facetted1445743facetted
falsettos1242713falsettos
fouettes1137883fouettes
fumettes1345773fumettes
gaieties9310183gaieties
galeate83916783galeate_
galeated104111573galeated
galenites10129183galenites
galeres83514323gale_res
gallates92815523gallates
gametes10312253game_tes
garottes978283garottes
gavottes1274183gavottes
gayeties1236883gayeties
gazette17357363gazette_
gazetted19234853gazetted
genettes938303genettes
halites103221193hal_ites
halteres113414593halteres
jadeites1645823jadeites
lattes65324203__lattes
layette1037133layette_
lethes94818083__lethes
letted74118543__letted
letter63722583__letter
letters73819853__letters
lottes65322753__lottes
lunettes836753lunettes
malates93522603mal_ates
maleate94117543maleate_
malemutes1344453malemutes
maquettes2045913maquettes
mattes85624533ma__ttes
mofettes1386083mofettes
musettes1037433musettes
navette1036983navette_
octettes1045533octettes
oleates7417833_oleates
omelettes1144743omelettes
opalesces1343983opalesces
paillette1145243paillette_
palaces114216453pal_aces
palatals1037773palatals
palate84226783pal_ate_
palatines11313013palatines
paleae84820293pale_ae_
palefaces1645303palefaces
paleness10312983paleness
pales75753803pal___es
palest83926223palest__
palestra1045883palestra
palestras1145723palestras
palet74650803pale_t__
paletot9413713pale_tot
paleways1645833paleways
palewise1346423palewise
palleted1139863palleted
palletise11127633palletise
palletises1247223palletises
palletizes2176433palletizes
pallets93919303pallet_s
palliates11311033palliates
palmate113215233palmate_
palmated132511003palmated
palmetto1244983palmett_o
palmitates1445453palmitates
palmtops1443543palmtops
palpate113213923palpate_
palpated13249763palpated
palpitates1445303palpitates
palsies94420273pal_sies
palter84423263pal__ter
paltered113012483paltered
palterer102411273palterer
palterers11249533palterers
palters94021683pal_ters
pancettas1343993pancettas
panettones1243893panettones
pantalettes1353253pantalettes
panties94230933pa_nties
parented11912213parented
parents93418123parent_s
pareses94718873pare_ses
paretics122312443paretics
pargetted1345663pargetted
parietes10714543parietes
parities10522973parities
parkette14138023parkette_
parties93230863pa_rties
pastes85233913pa__stes
pasties94529813pa_sties
patented1188893patented
patentee1099943patentee
patentees1196543patentees
patents94815203patent_s
pates76047893pa___tes
patted94724683pa__tted
pattee84323383pa__ttee
patten84418193pa__tten
pattens95414923pa__ttens
patter84628263pa__tter
patters94825193pa__tters
patties93425143pa_tties
paupiettes1442603paupiettes
payees114812903paye__es
pelites93821993pel_ites
petites93820203p__etites
petted94121523p__etted
petter83924773p__etter
petters93722363p__etters
pettles93916483p__ettles
pieties9419223p_ieties
pileate93815923pileate_
pileated112711133pileated
pipette1137943pipette_
pipetted1335263pipetted
placates12311753placates
plates85432243p_l_ates
platies93722543p_laties
platted103614263p_latted
platter93917413p_latter
platters103415283p_latters
pleases94515483p_leases
pleated103816633p_leated
pleater93916333p_leater
pleaters103613783p_leaters
pleats85218593p_leat_s
plebes104313623p_le_bes
pledges113811563p_ledges
plenties10314693p_lenties
plexes155313533p_le_xes
plotted104612373p_lotted
plotter94113663p_lotter
plotters104011553p_lotters
plotties103111413p_lotties
plotzes18317693p_lotzes
poleaxes1767273poleaxes
polentas1038743polentas
polities102722343polities
pollutes1037613pollutes
prelates10418563prelates
pretties10615133p_retties
proette9312363proette_
pulsates1048813pulsates
raclette1047643raclette_
reletter81311023reletter
reletters9138783reletters
rillettes946533rillettes
rosettes8310343rosettes
roulettes946523roulettes
safeties1139163safeties
salties73725773sal_ties
salutes73716253sal_utes
syrettes1136963syrettes
tabletted1244833tabletted
talented938423talented
talents7312013talent_s
toilettes946023toilettes
tonettes839203tonettes
unletted9310313unletted
valences1388513valences
valerates12310533valerates
valeted1139013vale_ted
valets93715623vale_t_s
valuates112811193valuates
vedettes1265933vedettes
videttes1266333videttes
waltzes1935953wal_tzes

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622318.51617163.2
3Display Results2312310.0932483.9
 (SQL Overall)1786912318.78220347.4
 
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.