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

258 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
stammel1160753(None) 
stammels12495561stammels
stammer116013341stammer
samiel8313332s_amiel
scammed14479542scammed
scammer133611972scammer
shammed153911422shammed
shammer144613142shammer
shammes144312832shammes
slammed123511102slammed
slammer113913032slammer
spammed14348522spammed
spammer133410432spammer
stamen84115942sta_men
stammers123611522stammers
stamped124812812stamped
stamper113714402stamper
staumrel1042082staumrel
stemmed12278152stemmed
stemmer113210182stemmer
stummed12348552stummed
trammel11357662trammel
bammed133913243_bammed
camel96822803_ca_mel
clammed14369963clammed
clammer134211793clammer
crammed143710123crammed
crammer134010963crammer
dammed124214793_dammed
dammer114317933_dammer
damsel9148033_damsel
drammed13378073drammed
enamel81210113ena_mel
flammed15377413flammed
gammed124216163_gammed
gammer1112318333_gammer
gramme114210333gramme_
grammes123611323grammes
hammal134512063_hammal
hammed144116973_hammed
hammer138120033_hammer
jammed183811503_jammed
jammer174014133_jammer
kummel14266173_kummel
lammed113915623_lammed
mammal95112753_mammal
mammee94417853_mammee
mammer94218863_mammer
mammet94319253_mammet
mammey124310893_mammey
pommel12277453_pommel
pummel12278043_pummel
rammed113117303_rammed
rammer103519653_rammer
sambal105215183s_ambal
same65245643s_a_me_
samek114915273s_a_mek
samiels939763s_amiels
samlet84126563s_amlet
sample104215013s_ample
satchel123310303satchel
saurel6511993s_aurel
scalpel11377713scalpel
scammers14339773scammers
scamped144711963scamped
scamper134613163scamper
scrammed1555003scrammed
scummed14347913scummed
scummer13398753scummer
seamed94823883sea_med
seamen84518563sea_men
seamer84223613sea_mer
seamier93114633seamier
shamble14149263shamble
shame105726703sha_me_
shamed125120213sha_med
shames114726223sha_mes
shammas14358723shammas
shammers153710843shammers
shammied16265543shammied
shammies15259693shammies
shammos14307203shammos
shammy16388503shamm_y
shimmed15338583shimmed
shimmer143310873shimmer
simmer104115353s_immer
simnel857023s_imnel
skimmed16306053skimmed
skimmer15327533skimmer
slammers123511223slammers
slimmed12368473slimmed
slimmer114211343slimmer
slummed12359273slummed
slummer113711203slummer
spammers14378693spammers
spancel1147363spancel
spaniel948923spaniel
spasmed12296993spasmed
stabbed123510373stabbed
stabber113610153stabber
stabile9312063stabile
stable83921643stable_
stabled103514953stabled
stabler94014933stabler
stables93219073stables
stacked143416123stacked
stacker134416263stacker
stacte82113913stacte_
stactes91914633stactes
staddle9288093staddle
stade64825303sta_de_
stades74626243sta_des
staffed14298283staffed
staffer13299093staffer
stage65330193sta_ge_
staged84521563sta_ged
stager74821343sta_ger
stages75629493sta_ges
stagey105915583sta_gey
stagged104212083stagged
stagger94212393stagger
stagier83513443stagier
staider83912613staider
stained84215343stained
stainer73614923stainer
stake95927533sta_ke_
staked114621943sta_ked
stakes103927293sta_kes
stale55637103sta_le_
staled74728103sta_led
stalely1039213sta_lely
staler64025823sta_ler
stales65538293sta_les
stalked123811173stalked
stalker113912253stalker
stall54722353sta__ll
stalled83515693stalled
stamened1137633stamened
stamens93411483stamens
stamina9310793stamina
staminal1046983staminal
stamineal1143103stamineal
stammered1444643stammered
stammerer1344063stammerer
stamp95217363sta_m_p
stampede13326163stampede
stampers124211603stampers
stamps105614023sta_mps
stance84316913stance_
stances93715963stances
standee83514513standee
stander84316163stander
stane55933003sta_ne_
staned74824643sta_ned
stanes64933403sta_nes
stanged94113843stanged
stanol6310723sta_nol
stapes85028733sta_pes
staple84415823staple_
stapled103613703stapled
stapler93913633stapler
staples93617213staples
stare54440263sta_re_
stared75429873sta_red
starer64027363sta_rer
stares66038753sta_res
starker114114693starker
starlet71620123starlet
starred85013453starred
started84217323started
starter73817883starter
startle72511123startle
starve94613743starve_
starved114911573starved
starver104611993starver
starves104614553starves
stases64225563sta_ses
stashed113812493stashed
stashes103916173stashes
statal61613223sta_tal
state56237333sta_te_
stated75427833sta_ted
stately10310223sta_tely
stater64427563sta_ter
states64337083sta_tes
statue66015323statue_
statued8459893statued
statues74614903statues
staumrels1141663staumrels
stave85324993sta_ve_
staved103918053sta_ved
staves94525193sta_ves
stayed104817273sta_yed
stayer94516483sta_yer
steamed103712143steamed
steamer93313093steamer
steamier1048303steamier
steel55721993st__eel
stemma10328133stemm_a
stemmas11256973stemmas
stemmers12378443stemmers
stemmery15334693stemmery
stemmier1245253stemmier
stemmy13417033stemm_y
stigmal10245923stigmal
stime76521803st_ime_
stimes85920573st_imes
stimied10310623stimied
stimies9316563stimies
stipel84412123st_ipel
stomal85213313st_omal
stomped124110533stomped
stomper114111233stomper
stormed1039043stormed
streel64214023st_reel
stromal93010593stromal
strudel835783strudel
strummed1344473strummed
strummer1234783strummer
stumble1147553stumble
stumped124210153stumped
stumper113610093stumper
stymie1137623stymie_
stymied1335663stymied
stymies1239213stymies
summed114014043s_ummed
summer104017713s_ummer
swagmen1334973swagmen
swamies123712063swamies
swamped15498443swamped
swamper14349313swamper
swarmed1367483swarmed
swarmer1247803swarmer
swimmer14297653swimmer
tael46030713_ta__el
tamal73522623_ta_mal
tamale83717403_tamale
tame66343663_ta_me_
tamed85528513_ta_med
tamely113711953_ta_mely
tamer75230103_ta_mer
tames75242013_ta_mes
tammie104212693_tammie
tammies113814683_tammies
tammy124013223_tamm_y
tamped114317043_tamped
tamper104618513_tamper
tassel66014773_tassel
taxmen15367443_taxmen
tommed113310143_tommed
tramel84113713_tramel
trammed123810713trammed
trammels12295413trammels
trommel11315363trommel
tsimmes1133673tsimmes
wadmel1235523_wadmel
whammed18345133whammed
yammer133713183_yammer

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 Filter1786911340270.500357382.0
2DLD Change Limit1340272586.09321996.9
3Display Results2582580.0962687.5
 (SQL Overall)1786912586.68926714.2
 
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.