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

156 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
strummer123478(None) 
strummed1344471strummed
strummers1333691strummers
drummer12407502_drummer
grummer12338782_grummer
rummer104715482__rummer
scrummed1554312scrummed
scummer13398752s_cummer
slummer113711202s_lummer
stammer116013342st_ammer
stemmer113210182st_emmer
streamer10239512streamer
strumae9368092strumae_
strumpet1256032strumpet
strutter846502strutter
stummed12348552st_ummed
stumper113610092st_umper
summer104017712s__ummer
thrummer1542932thrummer
trimmer113610832_trimmer
brimmer13348803_brimmer
bummer124014103__bummer
crammer134010963_crammer
crimmer133310773_crimmer
crumber13339643_crumber
crummier1435603_crummier
cummer124414593__cummer
drummed13306323_drummed
drummers13316163_drummers
glummer12417983_glummer
grimmer123510093_grimmer
grummet12298873_grummet
gummer114615453__gummer
hummer133615273__hummer
krimmer15376873_krimmer
mummer93614543__mummer
plummer13298533_plummer
primmer134310163_primmer
rammer103519653__rammer
rimmer103516033__rimmer
rummers113513653__rummers
rummier11309563__rummier
scammer133611973s_cammer
scrammed1555003scrammed
screamer12267883screamer
scrimper1455763scrimper
scrubber1434123scrubber
scummed14347913s_cummed
scummers14277783s_cummers
scummier1445083s_cummier
shammer144613143s_hammer
shimmer143310873s_himmer
shrimper1544413shrimper
simmer104115353s__immer
sirupier1034303sirupier
skimmer15327533s_kimmer
slammer113913033s_lammer
slimmer114211343s_limmer
slumber113811003s_lumber
slummed12359273s_lummed
slummers12358933s_lummers
slummier1235473s_lummier
spammer133410433s_pammer
sprucer11317683spru_cer
sprucier1254793sprucier
spumier1137903s_pumier
stammel11607533st_ammel
stammers123611523st_ammers
stamper113714403st_amper
staumrel1042083staumrel
steamer93313093st_eamer
steamier1048303steamier
stemmed12278153st_emmed
stemmers12378443st_emmers
stemmery15334693st_emmery
stemmier1245253stemmier
stomper114111233st_omper
stormier1036103stormier
stouter74012053stou_ter
strafer103912463str_afer
strainer8512223strainer
straiter8311783straiter
strander97112063strander
stranger94715103stranger
strapper1258093strapper
strawier1137493strawier
strayer104312503str_ayer
streaker12229483streaker
streamed11258903streamed
streamers11228083streamers
streamier1155763streamier
streeker12206643streeker
strewer104310413str_ewer
stricter1039423stricter
strider84315723str_ider
striker113714173str_iker
stringer93812943stringer
striper94514793str_iper
stripier1058863stripier
stripper1247123stripper
striver104315203str_iver
stroker114113523str_oker
stroller848183stroller
stronger9349703stronger
stropper1247763stropper
stroyer103510783str_oyer
strucken1444323strucken
strudel835783stru_del
struggler11264553struggler
strum75619453stru_m__
struma84313273stru_m_a
strumas9419833stru_mas
strumming1454413strumming
strumose1044303strumose
strumous1045733strumous
strumpets1362893strumpets
strums84716453stru_m_s
strunted957243strunted
strutted946343strutted
strutters955703strutters
studier82510053st_udier
stuffer13349793st_uffer
stuiver10447083st_uiver
stumbler1235813st_umbler
stumped124210153st_umped
stumpers12318313st_umpers
stumpier1255883st_umpier
stunner7349193st_unner
sturdier9216963sturdier
stutter72911463st_utter
summed114014043s__ummed
summers113616503s__ummers
summery14329413s__ummery
surnamer1044883surnamer
swimmer14297653s_wimmer
syrupier1343053syrupier
thrummed1642843thrummed
thrummers1642413thrummers
thrummier1641793thrummier
thumper14356953_thumper
trammed123810713_trammed
trammel11357663_trammel
tramper113812163_tramper
trimer85717153_tr_imer
trimmed12348933_trimmed
trimmers12288913_trimmers
trommel11315363_trommel
trucker134010733_trucker
trudger9338733_trudger
truer54916643_tru__er
trumped12439713_trumped
trumpery1533613_trumpery
trumpet113810723_trumpet
trusser74010263_trusser
truster73114313_truster
tummler11266613_t_ummler

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 Filter1786911461620.440406115.9
2DLD Change Limit1461621567.46619577.0
3Display Results1561560.0632476.2
 (SQL Overall)1786911567.96922423.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.