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

524 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
salpid951087(None) 
salpids1038191salpids
sapid84720931sa_pid
alcid85817962_alcid
algid75415572_algid
elapid939542elapid
halid94424972hal_id
haloid104317752haloid
pallid93915272pallid
palped114513642palped
palpi95414552palpi_
rapid86422032ra_pid
said55742112sa__id
saiyid10167412saiyid
salad65321832sal_ad
salic73424712sal_ic
sallied83316952sallied
salmi7815862salmi_
salmis8514272salmis
salp64534092salp__
salpa75018352salp_a
salpae84614272salpae
salpas85116922salpas
salpian938492salpian
salpinx1636092salpinx
salps74423242salp_s
salted74121202salted
saltie63422422saltie
salved103916422salved
salvia93310752salvia
sapped114422012sapped
sayid95516722sa_yid
sayyid13185352sayyid
scalped124411992scalped
sialid7314932sial_id
sialoid8310952sialoid
slid55828982s_l_id
sloid64619692s_loid
solid65025072sol_id
stupid937592stupid
sulfid1039062sulfid
sulphid1346112sulphid
sylphid1645962sylphid
valid94618382val_id
vapid115614282va_pid
aalii5316123aal_ii
aaliis6312893aaliis
acid77533393_a_cid
acrid86920103_acrid
aid49269073_a__id
aland65526413_aland
alcids94812293_alcids
algin65718763_algin
algoid83011463_algoid
alif76242133_al_if
aliped95414283_aliped
alit46155693_al_it
alkie95520033_alkie
alkyd13537093_alkyd
allied74217153_allied
allod64418373_allod
almud84012183_almud
aloin55227413_aloin
aloud65018063_aloud
alp56641133_alp__
alpha1049653_alpha
alpine84417373_alpine
alps65529243_alp_s
amid77036333_a_mid
amped104820513_amped
aped78538153_a_ped
aphid115515393_aphid
apod78123183_a_pod
arid57642713_a_rid
aroid65428333_aroid
aspic95114733_aspic
aspis74618143_aspis
avid88325963_a_vid
avoid95516673_avoid
bald76432903bal__d
balded105417513balded
baled85436443bal_ed
balked135219413balked
ballad94315323ballad
balled94926893balled
caid77837533ca__id
calcic9311873calcic
calif104929093cal_if
caliph13311403caliph
calix145317343cal_ix
calked134617403calked
calkin123515493calkin
called94126733called
calmed114816383calmed
calpac123211063calpac
calpain11310413calpain
calved125215453calved
camped134720233camped
campi116217783campi_
candid104517853candid
canid85526343ca_nid
caped104931803ca_ped
capiz18514563ca_piz
caplin103216303caplin
capped134721853capped
capsid11312413capsid
carped115923763carped
carpi94319393carpi_
chalcid1537873chalcid
coalpit1148503coalpit
cupid103212783_cupid
cuspid11429213cuspid
dallied93713603dallied
damped124315583damped
dapped124516763dapped
elapids1036503elapids
falsie93513853falsie
felid94717173fel_id
fluid94013963_fluid
fulgid1137043fulgid
gadid85517373ga_did
gadoid9310443gadoid
galled84622853galled
gallic9411633gallic
gallied94114993gallied
galoped11138063galoped
ganoid8314433ganoid
gaped96123533ga_ped
gapped124217123gapped
gasped104814293gasped
gawped13509073gawped
gelid74916973gel_id
gulped104610373gulped
haled95335823hal_ed
halide103417993hal_ide
halids104016133hal_ids
haloed104717593haloed
haloids113012543haloids
halted105019603halted
halved134813903halved
haploid1339823haploid
happed144820103happed
harped124418403harped
harpin113614383harpin
hasped125014443hasped
hatpin112610603hatpin
helped124714153helped
hispid1238173hispid
hyaloid1439063hyaloid
inlaid7310133inlaid
jalapic1844543jalapic
jalapin1645923jalapin
japed156217633ja_ped
jassid1467223jassid
jauped16457903jauped
kalif125021353kal_if
kaliph1537873kaliph
kalmia1238893kalmia
kalpa114512193kalp_a
kalpac14428223kalpac
kalpak11437243kalpak
kalpas124112943kalpas
keloid11812613keloid
kelped13449543kelped
kelpie12308613kelpie
laid56439143__laid
lalled74218753lalled
lampad114510033lampad
lamped114017543lamped
lapin75222923la_pin
lapis76223153la_pis
lapped114320033lapped
lid47453513__l_id
limpid11389743limpid
lipid85916173_lipid
loid55531483__loid
magpie1139093magpie
maid75537633ma__id
malfed12369753malfed
malic94525653mal_ic
malkin122913143malkin
malled94626103malled
malted94819853malted
mantid93820373mantid
mapped134015883mapped
masjid16187313masjid
meloid9615993meloid
naled65525053nal_ed
napped114218163napped
nappie104112263nappie
navaid1037643navaid
ozalid1696673ozal_id
paid75737483pa__id
palais8420423palais
paled85538723pal_ed
palled94625163palled
pallia83015593pallia
palmed114314643palmed
palp85828573palp__
palpal104112053palpal
palping124112873palping
palps94719563palp_s
palpus104210283palpus
palsied102911303palsied
pappi84810893pappi_
pavid115717003pa_vid
placid114012543placid
plaid85118303_plaid
psalmed1234503psalmed
psalmic1345333psalmic
psyllid1344513psyllid
pulped114612533pulped
pulpit10310933pulpit
qaid146023843qa__id
rabid84520773ra_bid
raid55243073ra__id
rallied83514083rallied
ralph1078743ralp_h
ralphed1334363ralphed
ralphs1135373ralphs
ramped114617903ramped
rancid9513863rancid
ranid66429333ra_nid
raped85334623ra_ped
rapids94913893ra_pids
rapped114122683rapped
rasped94715203rasped
relaid75518443relaid
sabbed114518083sabbed
sabed86526813sa_bed
sabin74924943sa_bin
sabir75916993sa_bir
sabred95916533sabred
sacked135525213sacked
sacred94917103sacred
sad47459203sa___d
sadi55834643sa_di_
sadis64930853sa_dis
sagged94120003sagged
sahib10314753sa_hib
saids65328853sa__ids
sail45447163sa__il
sailed74327763sailed
saimin8313663saimin
sain45551293sa__in
sained75424243sained
saiyids11174893saiyids
saki85628473sa_ki_
sakis95323663sa_kis
sal36462883sal___
salaam8711013salaam
salads75316963salads
salal55425703sal_al
salals65120083salals
salami8313103salami
salamis9313513salamis
salaried9311023salaried
salary9515213salary
sale44959703sal__e
salep77022953sal_ep
saleps85014903saleps
sales56055593sal_es
salicin9311223salicin
salified12310363salified
salify12311373salify
salina64221123salina
saline65132703saline
saliva93110743saliva
sall44544683sal__l
sallet63734543sallet
sallier73320423sallier
sallies73227813sallies
sallow94315753sallow
sally85129713sal_ly
salmon84614183salmon
salmonid1147633salmonid
salol55222143sal_ol
salols64017873salols
salon55228553sal_on
salons63823683salons
saloon64418023saloon
saloop84212583saloop
salpians1036763salpians
sals46851673sal__s
salsa56718923sal_sa
salsas65316133salsas
salsify1334703salsify
salt45758523sal__t
salter64325083salter
saltier74318633saltier
salties73725773salties
saltily10310543saltily
saltine75018563saltine
salting84120793salting
saltire73113033saltire
saltish10312163saltish
saltpan935303saltpan
salts55431883sal_ts
salty85524383sal_ty
saluki1036203saluki
salukis1136033salukis
salute64418023salute
saluted84511703saluted
salve85022133sal_ve
salver94617753salver
salves94221763salves
salvias10279933salvias
salving113913153salving
salvo84415643sal_vo
salvoed11307063salvoed
salvor94711093salvor
salvos94613383salvos
samp85733593samp__
sampan102511893sampan
sample104215013sample
sampled123410783sampled
samps96124673samp_s
sand55338463sa__nd
sanded84920613sanded
sandpit1049633sandpit
saned65636273sa_ned
santir6315243santir
sap56463233sa_p__
sapling103217863sapling
sapor75119253sa_por
sapper103822353sapper
sapphic1644553sapphic
sappier113613113sappier
sappily1437163sappily
sapping123519313sapping
sappy125413473sa_ppy
saps65346373sa_p_s
sarcoid10310453sarcoid
sard55344243sa__rd
sari45444043sa_ri_
sarin55239253sa_rin
saris54544953sa_ris
sarod65325873sa_rod
sashed105622943sashed
sasin54626573sa_sin
sassed76116173sassed
sated66238533sa_ted
sati45539323sa_ti_
satin55935213sa_tin
satis55633673sa_tis
satyrid1137233satyrid
sauced93913303sauced
sauted74119603sauted
saved95127113sa_ved
savin84625083sa_vin
savvied1433803savvied
sawed95628403sa_wed
sayed96127143sa_yed
sayids104310973sa_yids
sayyids14193833sayyids
scald84818123scal__d
scalded11409763scalded
scaldic1235943scaldic
scaled94822443scal_ed
scalp95217983scalp__
scalpel11377713scalpel
scalper113912923scalper
scalping133410453scalping
scalps104315233scalp_s
scamped144711963scamped
scampi12469103scampi_
scaped115519553scaped
scarped124314393scarped
scoped115116653scoped
sculped12398253sculped
sculpin11236653sculpin
sealed74328363seal_ed
seeped94317523seeped
selfed10310913selfed
selkie102811693selkie
sepaloid1146753sepaloid
sepia75318673s_epia
sepic94617053s_epic
shaled105023953shal_ed
shaped125020103shaped
sharped134112043sharped
sharpie1238383sharpie
shilpit1247093shilpit
sialic8313633sial_ic
sialids839723sial_ids
sild55030583sil__d
silked114314813silked
silkie103313403silkie
siloed74615303siloed
silted74020013silted
silurid837013silurid
siped84927683s_iped
sipped113720633sipped
skald104210173skal__d
skaldic1443543skaldic
skelped1435203skelped
skelpit1344933skelpit
skid95720913s__kid
slain54923573s_lain
slaked114318273slaked
slap66434043slap__
slapped123511843slapped
slaps76025713slap_s
slated75028313slated
slaved104017043slaved
slayed104716223slayed
sled55334373s_l_ed
slide64725413s_l_ide
slim66631953s_l_im
slip67031733s_l_ip
slipe75626133s_lipe
sliped95417063sliped
slips76023723s_lips
slipt76627483s_lipt
slit46250103s_l_it
sloids73712693s_loids
slojd13378843s_lojd
sloped94216853sloped
sloyd9409683s_loyd
slued64220513s_lued
smalti84111173smalti_
snapped124611203snapped
sniped94913483sniped
soaped95817973soaped
soland75115043soland
sold54837413sol__d
soldi65717193soldi_
soled65835173sol_ed
solei55624333solei_
soli46637003sol_i_
solidi73813153sol_idi
solids74116403sol_ids
soloed74515743soloed
solved105312933solved
sopped114819903sopped
sordid83411153sordid
souped95017673souped
spalled103113123spalled
sparid94016933sparid
sparoid102311533sparoid
sped76031493s__ped
spic85227433s__pic
spied85427713s__pied
spik105419713s__pik
spin66231303s__pin
spit65545083s__pit
spiv95917793s__piv
split75729013spl_it
spud75818493s__pud
squalid1737043squal_id
squid154211903s_quid
staid66722073s_taid
staled74728103stal_ed
stalked123811173stalked
stalled83515683stalled
stamped124812813stamped
stapled103613693stapled
stiped94517073stiped
stolid74213173stolid
stoped94721013stoped
stupids1035273stupids
styloid1137543styloid
sulci7615053sulci_
sulfide1138103sulfide
sulfids1137293sulfids
sulked114314703sulked
sullied83714483sullied
sulpha1135403sulpha
sulphide1444623sulphide
sulphids1444373sulphids
supped114415703supped
swamped15498443swamped
swapped15429143swapped
swiped123811093swiped
syli74318983syl_i_
sylis84316023syl_is
sylph1347793sylp_h
sylphic1745883sylphic
sylphids1743953sylphids
sylphs1435543sylphs
sylphy1744153sylphy
sylvin12247303sylvin
syrphid1646103syrphid
tabid84418253ta_bid
tabloid1048253tabloid
talced93811003talced
tali46837163tal_i_
taliped1078203taliped
talked114015403talked
talkie103914443talkie
tallied83314753tallied
tallis63319963tallis
tallit63422733tallit
tamped114317043tamped
taped85327423ta_ped
tapir75917063ta_pir
tapis75028863ta_pis
tapped113820053tapped
tawpie11339143tawpie
taxpaid1743093taxpaid
tepid8314313_tepid
toluid738213toluid
torpid9310913torpid
trepid9310083trepid
unlaid7311753unlaid
valgoid1255203valgoid
valued104011153valued
valved136711043valved
vamped144211013vamped
vespid1246083vespid
waled94330993wal_ed
walked145313783walked
walled104021293walled
wallie93216803wallie
wapped144416473wapped
warped124816413warped
waylaid1445083waylaid
xyloid1738183xyloid
yald86920603yal__d
yapped144415143yapped
yauped12408333yauped
yawped15528103yawped
yelped12439363yelped
zapped204213523zapped

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127165245.86019234.8
3Display Results5245240.1563359.0
 (SQL Overall)1786915246.15629027.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.