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

528 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
sampler11321201(None) 
ampler104313301_ampler
sample104215011sample_
sampled123410781sampled
samplers12299401samplers
samples112815451samples
simpler112910861simpler
ambler104916442_ambler
ample94720302_ample_
camper124722212camp_er
campier133313272campier
damper114117752damp_er
gambler123612682gambler
hamper134518652hamp_er
pamper124316662pamp_er
rambler113313262rambler
saddler93811962saddler
sailer63526102sa_iler
samlet84126562sam_let
sapper103822352sa_pper
sappier113613112sappier
scamper134613162scamp_er
semple103212752semple_
simper103616292simp_er
simple104315172simple_
simples113014942simples
simplex18256392simplex
smaller93410332smaller
smiler83916682s_miler
stamper113714392stamp_er
stapler93913622stapler
sumpter1138872sumpter
suppler1148432suppler
swamper14349312swamp_er
swampier1544592swampier
tamper104618512tamp_er
trampler12278002trampler
vamper134212652vamp_er
vampier14308232vampier
abler75624313_a_bler
ambeer104511593_ambeer
amber94523203_am_ber
amble95924633_amble_
ambled115116353_ambled
amblers115213563_amblers
ambles105121853_ambles
ameer75618983_am_eer
amole75724593_amole_
amoles84122193_amoles
amped104820513_amp_ed
ampere10514413_amp_ere
amplest11312333_amplest
amply125012913_ampl_y
ampule10710613_ampule_
ampules1189433_ampules
amulet8419573_amulet
amuser84712623_amuser
angler74017863_angler
antler64615553_antler
aper66336233_a_p_er
apple94517673_apple_
apples104315763_apples
applet105917433_applet
applier1137903_applier
apter76120203_a_pter
ashler9459973_ashler
asper75520433_asp_er
babbler104012823babbler
baffler15418113baffler
bailer85425253ba_iler
baler75635273ba__ler
baller83825203ba_ller
battler94113383battler
bawler114315053ba_wler
bumbler134013233bumbler
bumper123714343bump_er
bumpier13359203bumpier
cabler104519173ca_bler
cackler153812573cackler
cajoler16398393cajoler
caller85125483ca_ller
camber124418473cam_ber
cameleer1246033cameleer
camlet104426583cam_let
camped134720233camp_ed
campers134220283camp_ers
camphor1636133camphor
candler103516593candler
caper94831623ca_p_er
caplet104226813ca_plet
capper124421983ca_pper
caroler93816753caroler
carper104923633carp_er
caviler1249063caviler
champer163813403champ_er
clamper134012993clamp_er
compeer133811553compeer
compiler1438373compiler
complex2037243complex
complier14310253complier
coupler114713013coupler
crampier14288903crampier
dabbler124012153dabbler
damager1157973damager
dammer114317933dam_mer
damner95213433dam_ner
damped124315583damp_ed
dampen114310593damp_en
dampener1335533dampener
dampers123915693damp_ers
damply14337893dampl_y
dandler94414273dandler
dangler96912813dangler
dapper114016633da_pper
dapple1138853dapple_
dappled1336393dappled
dapples1238993dapples
dawdler12356793dawdler
dazzler1634713dazzler
dimple113512793dimple_
dimpled132810303dimpled
dimples122813213dimples
dimplier1336673dimplier
dumper114615213dump_er
dumpier12409653dumpier
empaler11288353_empaler
enameler1045883enameler
ensample1242983ensample_
ensamples1343123ensamples
example1844283example_
exampled2043353exampled
examples1944313examples
fabler116115813fa_bler
faller94621233fa_ller
fumbler143610813fumbler
gabbler124013303gabbler
gambier124711963gambier
gamble115417183gamble_
gambled134112163gambled
gamblers13369733gamblers
gambles124016203gambles
gamer84928943gam__er
gamier93617933gam_ier
gammer1112318333gam_mer
gammier123711193gammier
gaoler73913573ga_oler
gaper86125123ga_p_er
gappier12369843gappier
garbler104012563garbler
gargler93710263gargler
gasper94515543gasp_er
gawper12499693gawp_er
gimpier12247933gimpier
grappler13336193grappler
hackler163512353hackler
haggler12328933haggler
hailer94720343ha_iler
haler85033523ha__ler
hamlet113722793ham_let
hammer138120033ham_mer
hammier143510653hammier
hamperer15379093hamperer
hampers143616943hamp_ers
hamster12810423hamster
hamular1236973hamular
handler113516163handler
happier143312033happier
harper115018403harp_er
hauler95015123ha_uler
hempier14319003hempier
humbler143411943humbler
humper134115883hump_er
humpier143110723humpier
impaler11298393_impaler
impled113812503_impled
jailer134316683ja_iler
jammer174014133jam_mer
jammier18408023jammier
jangler153811833jangler
japer146218883ja_p_er
jasper154610383jasp_er
jimper17389863jimp_er
jumbler183910273jumbler
jumper173612373jump_er
jumpier18317943jumpier
labeler92310183labeler
ladler74314933la_dler
lamber104418493lam_ber
lambier113611633lambier
lamer75233703lam__er
lamped114017543lamp_ed
lampers113817333lamp_ers
lamprey1434863lamprey
lamster9109913lamster
landler84113203landler
lapper104319953la_pper
lapser84113143la_pser
limper104117853limp_er
lumper103816653lump_er
lumpier113410143lumpier
mailer84724183ma_iler
mammer94218863mam_mer
mamzer19459833mam_zer
mangler103215643mangler
maple95521143ma_ple_
maples104819423ma_ples
mapper124516093ma_pper
marbler113511673marbler
mauler84416713ma_uler
miler75733063__miler
mumbler133510913mumbler
mumper123513523mump_er
nailer64119363na_iler
namer75622103nam__er
napper103718283na_pper
nappier114411173nappier
nimbler11358053nimbler
paddler113711553paddler
paler75436933pa__ler
pamperer14228333pamperer
pampero13328093pamp_ero
pampers133615933pamp_ers
pamphlet1745733pamphlet
paper95128663pa_p_er
pappier103511593pappier
pauper103511943paup_er
peopler1138073peopler
pimple123512963pimple_
pimpled14289183pimpled
pimples133012423pimples
pimplier1445413pimplier
pumper124415553pump_er
purpler11289263purpler
rabbler113514093rabbler
raffler13339223raffler
railer64524933ra_iler
ramble104519973ramble_
rambled123913513rambled
ramblers124010373ramblers
rambles113118313rambles
rammer103519653ram_mer
rammier112811023rammier
rampager1344453rampager
ramped114617903ramp_ed
rampole1139693rampole_
rampoles1238893rampoles
raper74932753ra_p_er
rapier84019993ra_pier
rapper104621573ra_pper
rasper83917323rasp_er
raspier93110633raspier
rattler74012743rattler
raveler104212463raveler
resample1244673resample_
resampled1454103resampled
resamples1344713resamples
rimple103814583rimple_
rimpled123311423rimpled
rimples113114223rimples
rippler113210103rippler
romper104213683romp_er
rumbler113514113rumbler
rumple103913013rumple_
rumpled123810013rumpled
rumples113313133rumples
rumplier1235303rumplier
saber75330243sa__ber
sable74732163sa_ble_
sables85026693sa_bles
sacker125124843sa_cker
sadder82916973sa_dder
saddle83915493saddle_
saddled103112033saddled
saddlers10289753saddlers
saddlery13274913saddlery
saddles95415743saddles
safer84721813sa__fer
sager65432053sa__ger
sagger84321073sa_gger
saggier92912063saggier
sagier73717163sa_gier
sailed74327763sa_iled
sailers73822313sa_ilers
sailor63113743sa_ilor
saker95132023sa__ker
sale44959703sa__le_
salep77022953sa__lep
sales56055593sa__les
sallet63734543sa_llet
sallier73320423sallier
salpae84614273salpae_
salter64325083sa_lter
saltier74318633saltier
saluter73512453saluter
salver94617753sa_lver
sambaed1238303sambaed
sambar103914163sam_bar
sambhar1444853sambhar
sambhur1453083sambhur
sambur10469503sam_bur
same65245643sam__e_
samek114915273sam__ek
samiel8313333sam_iel
samiels939763samiels
samisen937673samisen
samite83020603samite_
samites93118713samites
samlets93813553sam_lets
samovar1244243samovar
samoyed1335893samoyed
samp85733593samp___
sampan102511893samp_an
sampans112411003sampans
samphire1545823samphire
sampling13510643sampling
samps96124673samp__s
sander74828533sa_nder
sandier84017843sandier
saner54334323sa__ner
sanger74524563sa_nger
sapless93313443sa_pless
sapor75119253sa_p_or
sapour83812373sa_pour
sapped114422013sa_pped
sappers113518893sa_ppers
sarkier113413313sarkier
sassier73413233sassier
saucer84314103sa_ucer
saucier9810283saucier
sauger74316253sa_uger
saunter72913453saunter
savager1137133savager
saver84831253sa__ver
savorer1057883savorer
savvier1335483savvier
sawer85026213sa__wer
sawyer12438043sa_wyer
sayer84926553sa__yer
scaler84321603s_caler
scalper113912923scalp_er
scammer133611973scam_mer
scamped144711963scamp_ed
scamperer1544623scamperer
scampers143611033scamp_ers
scampies1439323scampies
scamster1235303scamster
scarper114814823scarp_er
scauper11379453scaup_er
scepter1138353scepter
scowler12248173scowler
scrambler15165043scrambler
sculler99812153sculler
scupper1367423scupper
sealer63928963s_ealer
seamer84223613seam__er
seamier93114633seam_ier
seamster1037143seamster
seepier92912013seepier
seller63824593s_eller
sempre102710093sempre_
settler73410653settler
shackler17317973shackler
shamble14149263shamble_
shambled16156153shambled
shambles15159043shambles
shammer144613143sham_mer
shampooer1643063shampooer
shaper114119933shap_er
sharper124312703sharp_er
sheller103515883sheller
shipper143514033shipper
shoaler102610073shoaler
shopper143312623shopper
sidler74716963s_idler
siller64026053s_iller
similar937853similar
simile83115623simile_
similes92915233similes
simmer104115353sim_mer
simperer1237173simperer
simpers113014113simp_ers
simplest122310223simplest
simply133010523simpl_y
simular938673simular
sipper103920983s_ipper
sizzler15266863sizzler
skimpier1634293skimpier
skipper15339563skipper
slammer113913033slam_mer
slapper113512463slapper
slipper113712973slipper
sloper84615913slop_er
smacker153410583smacker
smarter94113133smarter
smasher123911013smasher
smatter93613333smatter
smeller94212783smeller
smelter93311913s_melter
smile74823913s_mile_
smiled93716433s_miled
smilers94113843s_milers
smiles84522293s_miles
smiley114012303s_miley
smiter83616413s_miter
smoker124311693s_moker
smolder10327753s_molder
snapper113512073snapper
snappier1266213snappier
snarler73610633snarler
sneller73512843sneller
sniper84413643snip_er
snipper113911323snipper
soaper84517873soap_er
soapier93411713soapier
somber103713993som_ber
soppier112711583soppier
soupier93111753soupier
spaller92713473spaller
spammer133410433spam_mer
sparkler14317973sparkler
speer74623903s__peer
speller95415143speller
spieler93111233spieler
spier75728033s__pier
spiller92914323spiller
spoiler93310683spoiler
spooler93711383spooler
stabler94014933stabler
staler64025823s_taler
stammer116013343stam_mer
stamped124812813stamp_ed
stampeder14304343stampeder
stampers124211593stamp_ers
stampless1334543stampless
staple84415823staple_
stapled103613693stapled
staplers103111183staplers
staples93617213staples
startler8248783startler
stealer72913973stealer
stepper113010853stepper
stifler102911463stifler
stiller73414283stiller
stippler1235543stippler
stomper114111223stomp_er
stoper84320093stop_er
stopper113012593stopper
stumbler1235813stumbler
stumper113610093stump_er
stumpier1255883stumpier
styler94013303s_tyler
subtler92910843subtler
suckler133413093suckler
summer104017713sum_mer
sumpters1238023sumpters
super74924483s_up_er
supper104115433s_upper
supple10410203supple_
suppled1248463suppled
supples11511283supples
supplier1246603supplier
sutler63718393s_utler
swamped15498443swamp_ed
swampers15317473swamp_ers
swapper14359703swapper
sweller103012463sweller
swiller103211653swiller
swiple11379233swiple_
swiples12339643swiples
sypher14317083s_ypher
tackler134013323tackler
tailer63823733ta_iler
taler56034863ta__ler
taller63721963ta_ller
tamale83717393tamale_
tamales93216143tamales
tamer75230103tam__er
tamped114317043tamp_ed
tamperer12248893tamperer
tampers113516743tamp_ers
tangler83515073tangler
taper74829773ta_p_er
tapper104419613ta_pper
tattler73112213tattler
temper103914093temp_er
templar1145643templar
temple102811333temple_
templed12278553templed
temples112610893temples
templet112712003templet
tempter11358213tempter
tippler11348343tippler
tramper113812153tramp_er
trampier12318233trampier
trample11299703trample_
trampled13247903trampled
tramplers13305873tramplers
tramples122610203tramples
tumbler113412823tumbler
tummler11266613tummler
unsampled1444443unsampled
vamped144211013vamp_ed
vampers143111623vamp_ers
vampire14296673vampire
wabbler143511923wabbler
waddler124010793waddler
waffler16377783waffler
wailer93720323wa_iler
waler84229263wa__ler
wamble134415753wamble_
wambled153610753wambled
wambles143714023wambles
wamblier15275733wamblier
wangler113312653wangler
warbler123211463warbler
warper114015583warp_er
warsler10289893warsler
waspier12259053waspier
wimpier14248043wimpier
wimple133611363wimple_
wimpled15338823wimpled
wimples143311173wimples
yammer133713183yam_mer
yapper133714513ya_pper
yauper11368543yaup_er
yawper14437953yawp_er
zapper193414023za_pper
zappier20458373zappier

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.1561145455.1
2DLD Change Limit1340275287.28318402.7
3Display Results5285280.1862838.7
 (SQL Overall)1786915287.62523434.9
 
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.