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

420 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
sampans11241100(None) 
sampan102511891sampan_
tampans113310981tampans
damans94715982dam_ans
dampens12348562dampens
japans1539822ja_pans
lampads12477622lampads
lampas106615952lampa_s
pampas124913992pampa_s
pampeans1444702pampeans
rampant11312172rampant
salpas85116922salpa_s
salpians1036762salpians
saltpans1034812saltpans
sambals115213482sambals
sambars115113842sambars
sambas104219262samba_s
samples112815452samples
samps96124672samp__s
sarans64224432sa_rans
shamans123610902sham_ans
simians959202simians
somans84619302som_ans
spans74528732s__pans
swanpans1343422swanpans
taipans9269552taipans
tampan102512322tampan_
tampons112711552tampons
tarpans92513532tarpans
tympans14236812tympans
alans55636173_a_lans
amahs107819063_am_ahs
amas67746293_am_a_s
amass77119683_am_ass
amens75624843_am_ens
amias75831473_amia_s
amins75534323_am_ins
amping114317573_amping
amps86230343_amp__s
ampuls1098893_ampuls
appals104812943_appals
arpens84814823_arpens
ashcans1235183ashcans
aspens85013353_aspens
atamans9710433atam_ans
atmans84413963_atmans
avians93711563_avians
azans146516883_a_zans
banians9312033banians
banyans1237913banyans
bedpans1237173bedpans
bemeans1148733bemeans
bemoans1138253bemoans
caftans12179443caftans
caimans113811783caimans
callans94518473callans
calpacs133110343calpacs
calpains1239763calpains
camas96333523cam_a_s
camass104114183cam_ass
camions113916133camions
campagna1543413campagna
campagne1544413campagne
campaigns1643473campaigns
campers134220293campers
camping143118973camping
campings154010203campings
campions143511293campions
campong14318123campong
campongs15356123campongs
campos125217953camp_os
camps116330263camp__s
campus125213923camp_us
cancans11311873cancans
capons104119503ca_pons
captans111612053captans
carpals113414623carpals
caymans14349513caymans
champacs1934633champacs
champaks2134103champaks
claypans1543873claypans
company1619711143company
compas125817063compa_s
compass13379563compass
crampons1436643crampons
daman84821163dam_an_
damars93814993dam_ars
damiana1046563damiana
damianas1155573damianas
dammars12308193dammars
damns84916923dam__ns
dampen114310593dampen_
dampers123915693dampers
damping133414003damping
dampings14377523dampings
damps105220413damp__s
damsons1038013damsons
deadpans12205173deadpans
demeans1039713demeans
frypans1544053frypans
gamas85431363gam_a_s
gamays126310913gam_ays
gambas115817513gamba_s
gamelans11115843gamelans
gamins94420043gam_ins
gammas115714693gamma_s
gammons1237973gammons
gamps105323713gamp__s
grampas12399253grampa_s
hamals114816823ham_als
hammals14409223hammals
hammams13386443hammams
hampers143616953hampers
hamzahs24134373hamzahs
hamzas20119013hamza_s
happens14359173happens
hardpans1436453hardpans
harpins123615703harpins
hatpins123410643hatpins
hazans183411653ha_zans
hazzans18215783hazzans
humans112312433hum_ans
impawns1433323_impawns
inspans937803inspans
japan14411233ja_pan_
jawans1657843ja_wans
kaftans14185353kaftans
kalians11310183kalians
kalpacs15327133kalpacs
kalpaks12366163kalpaks
kalpas124112943kalpa_s
kampong16294933kampong
kampongs17293033kampongs
kamsins1346963kamsins
kanbans1337723kanbans
kapas116021733ka_pa_s
kappas144410363kappa_s
lagans75717783la_gans
lallans74113533lallans
lamas75532793lam_a_s
lamias85020613lamia_s
laminas93615873laminas
lampad114510033lampa_d
lampases1267293lampases
lampers113817333lampers
lamping123116003lamping
lampions12277973lampions
lampoons12266863lampoons
lamps95624833lamp__s
lapins84520683la_pins
lauans65113533la_uans
lemans85316393lem_ans
limans84816303lim_ans
limpas105513083limpa_s
lumpens11298263lumpens
magians10310753magians
mamas95930773mam_a_s
mambas125716243mamba_s
mammals10389273mammals
mammas94616403mamma_s
mammons1048513mammons
mannans93611523mannans
mans66354553__m_ans
means75831233__means
moans74624373__moans
naans55815253na__ans
napas75924353na_pa_s
nappas105511613nappa_s
oompahs1434263oompahs
paeans85118263pa_eans
paesans93312693paesans
pagans95717923pa_gans
paisans93614753paisans
pampa114913423pampa__
pampean1335543pampean_
pampers133615933pampers
pans65855733___pans
papains11312363pa_pains
papas94927493pa_pa_s
papaws13419113pa_paws
parians93519733parians
partans94418283partans
pavans115715593pa_vans
pawpaws1732823pawpaws
pompano1345203pompano
pompanos1445243pompanos
pompons1338553pompons
psammons1442783psammons
radians83013823radians
raglans82410133raglans
ramonas9311093ramonas
rampage1237453rampage
rampages1336673rampages
rampancy1743693rampancy
rampart11311993rampart
ramparts1245583ramparts
ramping123316873ramping
rampions12248023rampions
ramps96224633ramp__s
ramsons939563ramsons
randans8313213randans
ratans63819373ra_tans
rattans73411953rattans
remans84823003rem_ans
romans84620243rom_ans
sabals84618863sa_bals
sabbats1138633sabbats
sabins85521983sa_bins
sabras85116363sabra_s
sacrals93311793sacrals
saddens9309603saddens
sagas66025883sa_ga_s
saggars93610683saggars
saigas74114293saiga_s
saimins9312113saimins
sains55639973sa__ins
salaams997703salaams
salads75316963sa_lads
salals65120083sa_lals
salinas73116093salinas
salmons93713263salmons
salons63823693sa_lons
saloons74415313saloons
salpa75018353salpa__
salpae84614273salpa_e
salpian938493salpian_
salpids1038193salpids
salpinx1636093salpinx
salps74423243salp__s
salsas65316133salsa_s
saltant7316773saltant
saltpan935303saltpan_
samara8313853sam_ara
samaras9312913samaras
samba95618773samba__
sambaed1238303sambaed
sambaing1337113sambaing
sambal105215183samba_l
sambar103914163samba_r
sambhars1544833sambhars
sambos104315193sam_bos
samburs11369343samburs
samechs14285353samechs
samekhs16303923samekhs
sameks12409323sam_eks
samiels939763samiels
samisens1035483samisens
samites93118713samites
samlets93813553samlets
samosas939293samosas
samovars1343703samovars
samp85733593samp___
sample104215013samp_le
sampled123410793sampled
sampler113212013sampler
samplers12299403samplers
sampling13510643sampling
samplings1435553samplings
samsara936913samsara
samsaras1045873samsaras
samshus12125353samshus
samurais1046143samurais
sandals82715203sandals
sangars83116253sangars
sangas75222653sanga_s
sanjaks1834963sanjaks
sans45153363s___ans
sansars73313913sansars
sapiens9310173sapiens
sapors84118813sa_pors
sappers113518903sappers
sapping123519313sapping
saps65346373sa_p__s
saran53730303sa_ran_
sarapes94617743sarapes
sardana838643sardana
sardanas937813sardanas
sardars83112903sardars
sarins63932623sa_rins
sarsars73512143sarsars
sarsens7311393sarsens
sashays1336333sashays
sasins64923103sa_sins
satang75711563sa_tang
satangs8479713sa_tangs
satays94411683sa_tays
sateens73710753sateens
satins64930483sa_tins
satraps95011643satraps
saucepans1342173saucepans
saunas63915433sauna_s
saurians837763saurians
savant9416043sa_vant
savants1038653sa_vants
savins93923133sa_vins
scalepans1343823scalepans
scampers143611033scampers
scampies1439323scampies
scamping153510193scamping
scamps125014173scamp__s
scans74625103s__cans
seaman84015903seam_an_
seawans10379943seawans
secpars1138413secpars
sedans74816093s_edans
seitans73312303seitans
semens84616963sem_ens
sepals85217373s_epals
sewans95215903s_ewans
sextans14349263sextans
shaitans1136413shaitans
shaman113314283sham_an_
shamas113717943sham_a_s
shammas14358723shamma_s
shampoos1544603shampoos
sharpens13377813sharpens
shmears1277073shmears
shorans102812413shorans
shwanpans1741013shwanpans
siamang1045333siam_ang
siamangs1144063siam_angs
silvans10308333silvans
simars84916933sim_ars
simas75727553sim_a_s
simian8811163simian_
simlins9311843simlins
simoons937943simoons
simpers113014123simpers
simples113014943simples
simps94719763simp__s
skeans104512913s_keans
slogans8407983slogans
smears84714433s_mears
solans64122493s_olans
soldans83210403soldans
soman75024903som_an_
somas76030373som_a_s
soudans8309353soudans
sovrans1036483sovrans
sowans94215893s_owans
spaes76029973s__paes
spams94922193s__pams
span65234663s__pan_
spang84919733s__pang
spank115919573s__pank
spanks124514123s__panks
spars75431543s__pars
spas67036723s__pa_s
spats75031383s__pats
spawns11577923s__pawns
spays105520513s__pays
speans85417143s_peans
spins75327983s__pins
stamens93411483stam_ens
staminas1048853staminas
stampers124211603stampers
stamping133310963stamping
stamps105614023stamp__s
stewpans1343713stewpans
stupas83910883stupa_s
suldans8299723suldans
sultans72411833sultans
sumacs105512103sum_acs
summand1236263summand
summands1344713summands
summas104313163summa_s
summons1158003summons
sumps95023433sump__s
suntans72111733suntans
surpass938283surpass
swampers15317473swampers
swamping16307923swamping
swampland1741983swampland
swamplands1851693swamplands
swamps135910263swamp__s
swanpan1243693swanpan_
swans84625013s__wans
sylvans13235893sylvans
taipan82410663taipan_
tamals84116633tam_als
tambacs13219363tambacs
tambaks15218153tambaks
tameins9311413tameins
tampala1136613tampala
tampalas1245473tampalas
tampers113516743tampers
tamping122815813tamping
tampions12358113tampions
tampon102911233tampon_
tamps95524083tamp__s
tapas74627713ta_pa_s
tarpan82814293tarpan_
tarpons92612203tarpons
tartans72615823tartans
tarzans16329923tarzans
teopans939203teopans
timpana11226133timpana
timpani11266153timpani
timpano11235863timpano
tomans85419133tom_ans
trapans92812463trapans
trepans92311593trepans
tympan13257013tympan_
tympana14255853tympana
tympani14275923tympani
tympano14245283tympano
tympany17254603tympany
unmans82211993unm_ans
vampers143111623vampers
vamping152810233vamping
vamps125415483vamp__s
wampums16314213wampums
wampus13499013wamp_us
wangans1149503wangans
womans114613653wom_ans
yamens114010823yam_ens
yamuns11336513yam_uns
yapons114411773ya_pons
yaupons12345683yaupons
zamias174212923zamia_s

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274207.93616888.5
3Display Results4204200.3761117.0
 (SQL Overall)1786914208.46821101.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.