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

395 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
paleate9412000(None) 
galeate83916791galeate
maleate94117541maleate
palate84226791pal_ate
paleae84820291palea_e
palette93613981palette
palmate113215231palmate
palpate113213921palpate
pileate93815921pileate
alate55340332_al_ate
calceate1239862calceate
caseate9314782caseate
falcate12311622falcate
galeae74717452galea_e
galeated104111582galeated
galette84212702galette
gallate83417132gallate
malate84624562mal_ate
maleates103316342maleates
oleate6318882_oleate
palace104516922pal_ace
palates93624942pal_ates
palea75028662palea__
paleal84716672palea_l
paleface1545342paleface
palest83926222palest_
palet74650802pale_t_
palets85122312pale_ts
palettes103112832palettes
pallette1039512pallette
palliate10311892palliate
palmated132511002palmated
palmette1247732palmette
palpated13249762palpated
palpates122613062palpates
peltate92013772peltate
pileated112711132pileated
placate11312432placate
planate9314572planate
plate74635112p_l_ate
please84315732p_lease
pleat74734472p_leat_
pleated103816632p_leated
pleater93916332p_leater
pleats85218592p_leats
poleaxe1656302poleaxe
prelate9519692prelate
pulsate9510232pulsate
valerate11311472valerate
vallate103016562vallate
valuate102512732valuate
valvate133710812valvate
abate76627843_a_bate
ablate82219213_ablate
ablegate1147253ablegate
acerate92818913_acerate
acetate92514753_acetate
acuate8315633_acuate
aculeate1039923aculeate
adnate72913483_adnate
aerate64830553_aerate
agate66525153_a_gate
agemate101210583_agemate
agnate73314883_agnate
alae45643753_al_a_e
alane56135613_al_ane
alated75625153_al_ated
alates64833973_al_ates
albata839333_albata
albite8313313_albite
alcade91111513_alcade
alee46652323_ale__e
alert54740653_alert_
alerted82512223_alerted
alerter72111513_alerter
alerts64418223_alerts
algae65319623_alga_e
alienate8311553_alienate
alkane104313323_alkane
ansate64517863_ansate
aplenty1237173aplenty
aplite8316393apl_ite
appease1137913appease
areae55229743_area_e
arete56031353_are_te
aurate64426473_aurate
aureate72515283aureate
aviate9315203_aviate
baccate131011263baccate
balata8614683bal_ata
baldpate1345483baldpate
ballade104012563ballade
ballute938543ballute
barbate11314543barbate
blate75933783_bl_ate
bleat75737003_bleat_
bleated104015973_bleated
bleater94515303_bleater
bleats85518613_bleats
bolete8519613bole_te
bullate93415073bullate
calcite11413783calcite
caleche14297953caleche
califate13310483califate
calotte9510563calotte
calycate1537893calycate
carate84734003ca_rate
casease939323casease
caseated11310713caseated
caseates10313713caseates
casemate1239843casemate
casette9310393casette
catenate10312833catenate
caudate10311353caudate
caveat11417723caveat_
caveated1439133caveated
caveats1239803caveats
celeste949653celeste
chelate122914893chelate
ciliate9514603ciliate
clavate1238713clavate
cleat76335063_cleat_
cleated103417843_cleated
cleats84919313_cleats
cleave114212513_cleave
collate92919683collate
create85126383_create
cuneate9311723cuneate
daleth1038633dale_th
dealate83617843deal_ate
delate73827753del_ate
deleave1147723deleave
delegate10410463delegate
delete73620703dele_te
dilate73220693dil_ate
elate55335883_el_ate
elevate101110373_elevate
eluate62315433_eluate
epaulette1142783epaulette
epilate9314283epil_ate
evaluate11287793evaluate
facete115014833face_te
falcated1438483falcated
fellate10313433fellate
filiate10414233filiate
folate93320393fol_ate
foliate10513533foliate
foveate1338363foveate
galatea839973gal_atea
galea64722943galea__
galeas74618513galea_s
galenite91210063galenite
galere73716683gale_re
galettes93111163galettes
gallates92815533gallates
gamete9313593game_te
gazette17357363gazette
gelate73421263gel_ate
halest94823273halest_
halite93624233hal_ite
hamate113319833ha_mate
hastate10313913hastate
ideate7313683_ideate
jadeite1546403jadeite
kalifate1556493kalifate
karate105320923ka_rate
labiate91313573labiate
lacerate102214713lacerate
lactate9312703lactate
lanate6421263la_nate
late47560483__l_ate
laureate888023laureate
layette1037133layette
lease55230263__lease
leave84723723__leave
legate72917453__legate
lineate7815153lineate
macerate122314073macerate
magnate10512703magnate
makebate1645063makebate
malates93522613mal_ates
malemute1244923malemute
maltase938903maltase
mammate104411273mammate
mandate10315573mandate
mileage10299313mileage
narrate7313493narrate
nauseate845893nauseate
navette1036983navette
nucleate1048673nucleate
oblate82214743obl_ate
ocreate93711743ocreate
oleates7417833_oleates
opalesce1243513opalesce
oxalate1457623oxal_ate
package16128013package
paean77222723pa_ea_n
paeans85118263pa_eans
pageant10312783pageant
pageants1136693pageants
paginate114012443paginate
paillette1145243paillette
palaced124110783pal_aced
palaces114216463pal_aces
palais8420423pal_ais
palapa10310673pal_apa
palatal9310153pal_atal
palatine10316073pal_atine
palaver1238753pal_aver
pale66055013pal___e
paled85538723pale__d
palefaces1645303palefaces
palely11311933pale_ly
paler75436933pale__r
pales75753803pale__s
palestra1045893palestra
palestrae1145383palestrae
paletot9413713paletot
paletots1047803paletots
paleways1645833paleways
palewise1346423palewise
paliest93021613paliest_
palisade1145833palisade
pallet84232653pallet_
palleted1139873palleted
pallets93919303pallets
pallettes1148803pallettes
palliated1238493palliated
palliates11311033palliates
palmar104113463palma_r
palmary14338553palmary
palmately1644443palmately
palmettes1346883palmettes
palmetto1244983palmetto
palmitate1346413palmitate
palpable1448033palpable
palpal104112053palpa_l
palpator1247133palpator
palpitate1365973palpitate
palter84423263pal__ter
pancake1536673pancake
papillate13127573papillate
parade94720643pa_rade
parae76335703pa_ra_e
parbake1538353parbake
parent83230423parent_
parented11912213parented
parents93418123parents
pareve114613013pare_ve
parkade1437583parkade
parkette14138023parkette
parlante1039693parlante
partake1339643partake
partite9317133partite
passade1039233passade
passage1039803passage
paste74932953pa__ste
pate65350463p___ate
patellate1147483patellate
patent84524923patent_
patented1188893patented
patentee1099943patentee
patents94815203patents
patinate103016313patinate
patriate10311933patriate
pavane114113443pa_vane
pawnage1335873pawnage
payee105524723paye__e
peace95026083p__eace
peage84723573p__eage
pease75231113p__ease
peat65967933p__eat_
peats76140193p__eats
peaty105725693p__eaty
pectate112214693pectate
pedate93117763p_edate
pelage9515363pel_age
pelite84323003pel_ite
pennate93314033pennate
permeate12311613permeate
phenate12412203phenate
phonate12411813phonate
phorate12413363phorate
picrate112014143picrate
pilea75123953pilea__
pillage103412603pillage
pinnate93613743pinnate
pipeage1236203pipeage
pipette1137943pipette
pirate82322883p_irate
placated1338453placated
placater1238013placater
placates12311753placates
place94824613p_l_ace
plage84520403p_l_age
plane74929143p_l_ane
plat66048873p_l_at_
platane93112303platane
plated95225773p_l_ated
platen84518203p_l_aten
plater84427693p_l_ater
plates85432243p_l_ates
plats75531373p_l_ats
platy105021663p_l_aty
playdate1465263playdate
playmate1566463playmate
plea66830603p_lea__
pleach134211243p_leach
plead85818463p_lea_d
pleaded113511263p_leaded
pleader103511753p_leader
pleads94613953p_leads
pleas75627033p_lea_s
pleased103712073p_leased
pleaser93912343p_leaser
pleases94515483p_leases
pleaters103613793p_leaters
pleather1356653p_leather
plebe95014873p_le_be
pledge10469493p_ledge
plenty11311413p_lenty
plicate11314513plicate
plumate1149803plumate
poleax1547993polea_x
poleaxed1854823poleaxed
poleaxes1767273poleaxes
polecat11313143polecat_
polecats1248833polecats
polenta9310093polenta
polite83625073pol_ite
pollenate1157143pollenate
pollute937383pollute
prate75135983p__rate
predate10616893predate
prelates10418573prelates
primate111516283primate
private121513263private
probate11414483probate
proette9312363proette
prolate9419793prolate
pronate9418873pronate
prorate9418733prorate
pulsated1136853pulsated
pulsates1048813pulsates
pupate104213123p_upate
racemate1239063racemate
raclette1047643raclette
radiate83416313radiate
ramate83921693ra_mate
relate64033633rel_ate
release7312763release
relegate9311243relegate
roseate7613453roseate
saccate111311763saccate
saleable10312023saleable
salivate11310013salivate
salpae84614273salpa_e
salute64418023sal_ute
salvage1138193salvage
satiate7315403satiate
savate9313783sa_vate
selenate81712533selenate
slate55438283_sl_ate
sleave94714153_sleave
sleaze152611863_sleaze
solate64526073sol_ate
solvate102710213solvate
spoliate1039243spoliate
stalemate1146643stalemate
sulcate9314423sulcate
sulfate10311653sulfate
tablemate1344833tablemate
tailgate946823tailgate
talent6323323talent_
talented938423talented
talents7312013talents
tallage82712073tallage
tannate71813523tannate
tolerate8312323tolerate
toluate7159343toluate
trabeate1049483trabeate
vacate11314553va_cate
valence1268773valence
valerates12310543valerates
valet84337873vale_t_
valeted1139013vale_ted
valets93715623vale_ts
validate1239003validate
valuated12239203valuated
valuates112811203valuates
variate101316433variate
velate93720143vel_ate
volvate13317993volvate
vulgate11388433vulgate
vulvate13388323vulvate

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273956.46620728.0
3Display Results3953950.1432762.2
 (SQL Overall)1786913957.01525472.7
 
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.