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

538 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
stammer11601334(None) 
scammer133611971scammer
shammer144613141shammer
slammer113913031slammer
spammer133410431spammer
stammel11607531stammel
stammers123611521stammers
stamper113714401stamper
stemmer113210181stemmer
clammer134211792clammer
crammer134010962crammer
dammer114317932_dammer
gammer1112318332_gammer
hammer138120032_hammer
jammer174014132_jammer
mammer94218862_mammer
rammer103519652_rammer
scammed14479542scammed
scammers14339772scammers
scamper134613162scamper
scummer13398752scummer
seamer84223612sea_mer
seamier93114632seamier
shammed153911422shammed
shammers153710842shammers
shammes144312832shammes
shimmer143310872shimmer
simmer104115352s_immer
skimmer15327532skimmer
slammed123511102slammed
slammers123511222slammers
slimmer114211342slimmer
slummer113711202slummer
spammed14348522spammed
spammers14378692spammers
stabber113610152stabber
stabler94014932stabler
stacker134416262stacker
staffer13299092staffer
stager74821342sta_ger
stagger94212392stagger
stagier83513442stagier
staider83912612staider
stainer73614922stainer
staler64025822sta_ler
stalker113912252stalker
stamen84115942sta_men
stammels12495562stammels
stammered1444642stammered
stammerer1344062stammerer
stamped124812812stamped
stampers124211602stampers
stander84316162stander
stapler93913632stapler
starer64027362sta_rer
starker114114692starker
starter73817882starter
starver104611992starver
stater64427562sta_ter
stayer94516482sta_yer
steamer93313092steamer
steamier1048302steamier
stemmed12278152stemmed
stemmers12378442stemmers
stemmery15334692stemmery
stemmier1245252stemmier
stomper114111232stomper
strummer1234782strummer
stummed12348552stummed
stumper113610092stumper
summer104017712s_ummer
swamper14349312swamper
swarmer1247802swarmer
swimmer14297652swimmer
tamer75230102_ta_mer
tamper104618512_tamper
yammer133713182_yammer
aimer75926823__aimer
amber94523213__amber
ameer75618983__ameer
armer76924443__armer
bammed133913243_bammed
beamier113411943beamier
blamer104417143bla_mer
brimmer13348803brimmer
bummer124014103_bummer
calmer105216933_calmer
camber124418483_camber
camper124722213_camper
chamber164011063chamber
chamfer17399863chamfer
champer163813413champer
charmer144913663charmer
claimer11279883claimer
clamber133311743clamber
clammed14369963clammed
clammers143510693clammers
clammier1435843clammier
clamper134012993clamper
crammed143710123crammed
crammers14369353crammers
crimmer133310773crimmer
cummer124414593_cummer
dammar11438903_dammar
dammed124214793_dammed
dammers123214273_dammers
damner95213433_damner
damper114117753_damper
dimmer114112613_dimmer
drammed13378073drammed
drummer12407503drummer
emmer94314463__emmer
farmer115017373_farmer
flamer114919123fla_mer
flamier123112143flamier
flammed15377413flammed
foamer114714313foa_mer
foamier12339003foamier
framer114817443fra_mer
gamer84928943_ga_mer
gamier93617933_gamier
gammed124216163_gammed
gammers123214563_gammers
gammier123711193_gammier
glimmer12437713glimmer
glummer12417983glummer
grammar12406893grammar
gramme114210333gramme_
grammes123611323grammes
grimmer123510093grimmer
grummer12338783grummer
gummer114615453_gummer
hammed144116973_hammed
hammers144216063_hammers
hammier143510653_hammier
hamper134518653_hamper
harmer114719553_harmer
hemmer134112643_hemmer
hummer133615273_hummer
jammed183811503_jammed
jammers183710703_jammers
jammier18408023_jammier
krimmer15376873krimmer
lamber104418493_lamber
lamer75233703_la_mer
lammed113915623_lammed
limmer104314793_limmer
loamier9349163loamier
maimer104514593_maimer
mammee94417853_mammee
mammers104615693_mammers
mammet94319253_mammet
mammey124310893_mammey
mamzer19459833_mamzer
metamer1139613meta_mer
mummer93614543_mummer
namer75622103_na_mer
palmer105816543_palmer
pamper124316663_pamper
plummer13298523plummer
primmer134310163primmer
rammed113117303_rammed
rammers113715043_rammers
rammier112811023_rammier
reamer84325213rea_mer
rehammer1544653rehammer
rimmer103516033_rimmer
roamer84715163roa_mer
rummer104715483_rummer
saber75330243s_a_ber
sacker125124843s_acker
sadder82916973s_adder
safer84721813s_a_fer
sager65432053s_a_ger
sagger84321073s_agger
sagier73717163s_agier
sailer63526103s_ailer
saker95132023s_a_ker
salter64325083s_alter
salver94617753s_alver
sambar103914163s_ambar
sambur10469503s_ambur
same65245643s_a_me_
samek114915273s_a_mek
samiel8313333s_amiel
samlet84126563s_amlet
sampler113212013s_ampler
sander74828533s_ander
saner54334323s_a_ner
sanger74524573s_anger
sapper103822353s_apper
saucer84314103s_aucer
sauger74316253s_auger
saver84831253s_a_ver
sawer85026213s_a_wer
sawyer12438043s_awyer
sayer84926553s_a_yer
scaler84321603sca_ler
scalier94316913scalier
scalper113912923scalper
scamped144711963scamped
scampers143611033scampers
scamster1235303scamster
scanner94411813scanner
scanter94215183scanter
scarcer113911373scarcer
scarer84524613sca_rer
scarfer124511083scarfer
scarier94017873scarier
scarper114814823scarper
scatter93815173scatter
scauper11379453scauper
schemer1477963schemer
schmeer1475363schmeer
scrammed1555003scrammed
scummed14347913scummed
scummers14277783scummers
scummier1445083scummier
sealer63928963sea_ler
seamed94823883sea_med
seamen84518563sea_men
seamers94719433sea_mers
seamster1037143seamster
searer65432023sea_rer
seater64534163sea_ter
seemer84418043s_eemer
shader104218763sha_der
shadier113111153shadier
shaker134319463sha_ker
shakier143411153shakier
shalier103116423shalier
shame105726703sha_me_
shamed125120213sha_med
shames114726223sha_mes
shammas14358723shammas
shammied16265543shammied
shammies15259693shammies
shammos14307203shammos
shammy16388503shamm_y
shaper114119933sha_per
sharer95025483sha_rer
sharker144313813sharker
sharper124312703sharper
shatter103615703shatter
shaver123718913sha_ver
shimmed15338583shimmed
shimmers15269413shimmers
shimmery18265253shimmery
simmers113314613s_immers
simper103616293s_imper
skanker10268483skanker
skater105015493ska_ter
skimmed16306053skimmed
skimmers16296463skimmers
slabber113311393slabber
slacker133915293slacker
slaker104219273sla_ker
slalomer1045033slalomer
slander84015443slander
slapper113512473slapper
slasher104515333slasher
slater64429183sla_ter
slather103816083slather
slatier74016813slatier
slaver94419613sla_ver
slayer93916333sla_yer
slimier93212013slimier
slimmed12368473slimmed
slimmers12369633slimmers
slumber113811003slumber
slummed12359273slummed
slummers12358933slummers
slummier1235473slummier
smacker153410583smacker
smaller93410333smaller
smarmier1235033smarmier
smarter94113133smarter
smasher123911023smasher
smatter93613333smatter
snacker133112603snacker
snakier112810003snakier
snapper113512073snapper
snarer64620843sna_rer
snarler73610633snarler
soaker105717533soa_ker
soaper84517873soa_per
soapier93411713soapier
soarer64522243soa_rer
somber103714003s_omber
spacer104917793spa_cer
spacier114011633spacier
spader94317133spa_der
spaller92713473spaller
spanker133612353spanker
spanner94312563spanner
sparer84524963spa_rer
sparger103613083sparger
sparker133914363sparker
sparser94311483sparser
spasmed12296993spasmed
spatter94016523spatter
spawner12347363spawner
spumier1137903spumier
stabbed123510373stabbed
stabbers12268733stabbers
stable83921643stable_
stabled103514953stabled
stablers103611153stablers
stables93219073stables
stacked143416123stacked
stackers143413563stackers
stacte82113913stacte_
stactes91914633stactes
stade64825303sta_de_
stades74626243sta_des
staffed14298283staffed
staffers14247083staffers
stage65330193sta_ge_
staged84521563sta_ged
stagers84116673sta_gers
stages75629493sta_ges
stagey105915583sta_gey
stagged104212083stagged
staggers10379843staggers
staggery13346243staggery
staggier10167513staggier
stained84215343stained
stainers83212173stainers
stair54719943sta__ir
stake95927533sta_ke_
staked114621943sta_ked
stakes103927293sta_kes
stale55637103sta_le_
staled74728103sta_led
stales65538293sta_les
stalked123811173stalked
stalkers12369853stalkers
stalkier1257073stalkier
stalled83515693stalled
stamened1137633stamened
stamens93411483stamens
stamina9310793stamina
stammerers1443133stammerers
stammering1544523stammering
stamp95217363sta_m_p
stampede13326163stampede
stampeder14304343stampeder
stamps105614023sta_mps
stance84316913stance_
stances93715963stances
stancher13198813stancher
standee83514513standee
standers93514303standers
stane55933003sta_ne_
staned74824643sta_ned
stanes64933403sta_nes
stanged94113853stanged
stapes85028733sta_pes
staple84415823staple_
stapled103613703stapled
staplers103111203staplers
staples93617213staples
star48037763sta___r
stare54440263sta_re_
stared75429873sta_red
starers74522313sta_rers
stares66038753sta_res
starkers123712393starkers
starlet71620123starlet
starred85013453starred
starrier8279463starrier
started84217323started
starters83714773starters
startler8248793startler
starve94613743starve_
starved114911573starved
starvers11459643starvers
starves104614553starves
stases64225563sta_ses
stashed113812493stashed
stashes103916173stashes
state56237333sta_te_
stated75427833sta_ted
staters73922343sta_ters
states64337083sta_tes
stator64015483sta_tor
statue66015323statue_
statued8459893statued
statues74614903statues
stature74410683stature
staumrel1042083staumrel
stave85324993sta_ve_
staved103918053sta_ved
staves94525193sta_ves
stayed104817273sta_yed
stayers103813633sta_yers
steadier937313steadier
stealer72913983stealer
steamed103712143steamed
steamers103410873steamers
steeper93812773steeper
steer55423863st__eer
steerer73113633steerer
stemma10328133stemm_a
stemmas11256973stemmas
stemmy13417033stemm_y
stepper113010853stepper
sterner7411913sterner
sticker133515883sticker
stiffer13319393stiffer
stifler102911473stifler
stiller73414303stiller
stime76521803st_ime_
stimes85920573st_imes
stimied10310623stimied
stimies9316563stimies
stinger84314683stinger
stinker113313313stinker
stinter73614513stinter
stirrer7338233stirrer
stiver93915733st_iver
stocker133713083stocker
stoker104417623st_oker
stomped124110533stomped
stompers123610043stompers
stoner65823203st_oner
stonier72013793stonier
stooker113811733stooker
stooper93813193stooper
stoper84320103st_oper
stopper113012603stopper
storer64721673st_orer
stormed1039043stormed
stormier1036103stormier
stouter74012053stouter
stover94115643st_over
strafer103912463strafer
strainer8512223strainer
straiter8311783straiter
strander97112063strander
stranger94715103stranger
strapper1258093strapper
strawier1137493strawier
strayer104312503strayer
streamer10239513streamer
streamier1155763streamier
strewer104310413strewer
strider84315723strider
striker113714173striker
striper94514793striper
striver104315203striver
stroker114113523stroker
stroyer103510783stroyer
strummed1344473strummed
strummers1333693strummers
studier82510053studier
stuffer13349793stuffer
stuiver10447083stuiver
stumbler1235813stumbler
stumped124210153stumped
stumpers12318313stumpers
stumpier1255883stumpier
stunner7349193stunner
stutter72911463stutter
styler94013303st_yler
stymie1137623stymie_
stymied1335663stymied
stymies1239213stymies
suaver93014233sua_ver
summed114014043s_ummed
summers113616503s_ummers
summery14329413s_ummery
swabber14297963swabber
swager104013613swa_ger
swagger12389333swagger
swagmen1334973swagmen
swamies123712063swamies
swamped15498443swamped
swampers15317473swampers
swampier1544593swampier
swanker14369483swanker
swapper14359703swapper
swarmed1367483swarmed
swarmers1346323swarmers
swasher134011513swasher
swather134213603swather
swatter104113323swatter
swayer125210973swa_yer
swimmers15276693swimmers
swimmier15174313swimmier
taber73825823_ta_ber
tacker124224503_tacker
tagger84017713_tagger
tailer63823733_tailer
taker95229003_ta_ker
taler56034863_ta_ler
talker103916223_talker
taller63721963_taller
tambur10358713_tambur
tame66343663_ta_me_
tamed85528513_ta_med
tamers84224033_ta_mers
tames75242013_ta_mes
tammie104212693_tammie
tammies113814683_tammies
tammy124013223_tamm_y
tamped114317043_tamped
tampers113516743_tampers
tanker104521133_tanker
tanner63722293_tanner
taper74829773_ta_per
tapper104419613_tapper
tarter64023563_tarter
taster64930573_taster
tater54138613_ta_ter
tatter64024573_tatter
tauter64318023_tauter
tawer85223443_ta_wer
taxer125019363_ta_xer
taxmen15367443_taxmen
teemer85515743_teemer
temper103914093_temper
termer85717253_termer
timber104012683_timber
timer75626043_t_imer
tommed113310143_tommed
trammed123810713trammed
trammel11357663trammel
tramper113812163tramper
trimer85717153_trimer
trimmer113610833trimmer
tsimmes1133673tsimmes
tummler11266613_tummler
vamper134212653_vamper
vitamer1235473vita_mer
warmer113816733_warmer
whammed18345133whammed
yammers143410323_yammers

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.436409841.7
2DLD Change Limit1340275388.17316398.8
3Display Results5385380.1862892.5
 (SQL Overall)1786915388.79520317.3
 
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.