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 “strumas” 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
strumas941983(None) 
struma84313271struma_
strumae9368091strumae
strums84716451strum_s
estrums9208602estrum_s
satsumas1043572satsumas
scrums104614252scrum_s
serumal938782serumal
serums83916302serum_s
stemmas11256972stemmas
stigmas10206632stigmas
stomas84816322st_omas
stramash1344552stramash
stratas73013572stratas
streams94713372streams
stroma84313072stroma_
stromal93010582stromal
strum75619442strum__
strumose1044292strumose
strumous1045722strumous
strunts7429542strunts
struts65616802stru_ts
stumps104912282st_umps
stums75320082st_um_s
stupas83910882st_upas
traumas938582_traumas
trumps104611882_trumps
antrums969173antrum_s
aromas81018613_aromas
arums75517833_arum_s
asarums9467613asarum_s
asramas938303asramas
asthmas12117363ast_hmas
atmas75721013at__mas
atriums939043atrium_s
aurums849383aurum_s
brumal1049503_brumal
brumes106417073_brumes
chromas142512683chromas
crumbs12409233_crumbs
crumps124514343_crumps
curcumas1454853curcumas
dermas94116813der_mas
doumas95314813_doumas
dramas95814653_dramas
drums85415873_drum_s
dumas85420433__dumas
durums948153durum_s
estrual7367933estru_al
estrum81810513estrum__
estrus61912113estru__s
estruses838483estruses
ferulas103110753ferulas
forums114611843forum_s
frumps13479783_frumps
gastrulas1043623gastrulas
gramas94317203_gramas
grumes94415553_grumes
grumps114510573_grumps
jorums15408093jorum_s
karmas123013733kar_mas
kormas124511233kor_mas
korunas1135443korunas
larums83610533larum_s
loumas84812333_loumas
lumas75622913__lumas
lustrums1044663lustrum_s
mazumas2034623mazumas
morulas959703morulas
nostrums1045663nostrum_s
oestrums10156463oestrum_s
osteomas1045323osteomas
paruras9310533paruras
pneumas1145103pneumas
primas104418103_primas
pumas95121563__pumas
rostrums1046073rostrum_s
rumbas102512013__rumbas
rumps95922293__rumps
rums64833473__rum_s
sacrums11388043sacrum_s
sarcomas1247223sarcomas
satsuma943873satsuma_
saunas63915433s_aunas
schemas1468163schemas
scrams105216623scram_s
screams114810613screams
scrimps13517903scrimps
scrims104615933scrim_s
scrubs104210313scru_bs
scruffs1554173scruffs
scrum95418193scrum__
scubas103710223s_cubas
scums95017423s_cum_s
sebums10369813sebum_s
sedums93910483sedum_s
seriemas1047193seriemas
serosas7312663serosas
serum75223473serum__
sevrugas1242153sevrugas
shamas113717933s_hamas
shammas14358713shammas
shlumps1434143shlumps
shrimps14516753shrimps
shrubs11409213shru_bs
shrugs10469163shru_gs
sigmas94111353s_igmas
simas75727553s__imas
sirras63814863sir_ras
sirups83710533siru_ps
sistrums1055303sistrum_s
skuas95611733s_ku_as
slumps104313583s_lumps
slums74623433s_lum_s
smegmas1233503smegmas
solums85211333solum_s
somas76030373s__omas
soras55041013sor__as
sorus54527583soru__s
spirulas10207203spirulas
spruces113810503spruces
sprues84515763spru_es
sprugs94010173spru_gs
spumes1021314883s_pumes
stadias8411113stadias
stamps105614023st_amps
stanzas1636363stanzas
steams84916903steam_s
stellas72813033stellas
stemma10328133stemma_
stems75219953st_em_s
sterigmas1243563sterigmas
sternums1045783sternum_s
stigma9226753stigma_
stigmal10245913stigmal
stimes85920573st_imes
stoas55126023st__oas
stoma75918273st_oma_
stomal85213313st_omal
stomps105612833st_omps
storms85814603storm_s
stounds8377823stounds
stoups85313273stou_ps
stoures74614163stoures
stours65015623stou_rs
stouts65019003stou_ts
strafes104515993strafes
strains74218153strains
straits74916323straits
strakes114218073strakes
strands83711953strands
strap77925263str__ap
straps87721783str_aps
strass67117223str_ass
strata63616283strata_
stratal72710603stratal
straths102711713straths
stratums10266803stratum_s
stratus73011723stratus
straw813321293str__aw
straws98718673str_aws
stray88525573str__ay
strays96417933str_ays
streak104613623str_eak
streaks114411273streaks
stream84717283str_eam
streamy12509483streamy
streeks11378713streeks
streels73811343streels
streets73312613streets
streps86218063str_eps
stress66616673str_ess
strettas846423strettas
strews96817093str_ews
stria55723203str_ia_
striae65422273str_iae
stricks134310693stricks
strides84520393strides
strifes104716583strifes
strikes114719093strikes
strings84617133strings
stripes95320573stripes
strips85719653str_ips
strives104119373strives
strobes93813263strobes
strokes114316323strokes
strolls739183strolls
stromata1047593stromata
strops86220383str_ops
strouds837793strouds
strows96718273str_ows
stroys95914603str_oys
struck12489263stru_ck
strudel835783strudel
strudels934123strudels
strumatic1345763strumatic
strummed1344473strummed
strummer1234783strummer
strummers1333693strummers
strumpet1256033strumpet
strumpets1362893strumpets
strung75213023stru_ng
strunt64918913stru_nt
strut56030733stru__t
stubs75016073st_u_bs
studs64415873st_u_ds
stuffs123810223st_uffs
stulls63912973st_ulls
stum65526013st_um__
stump94616463st_um_p
stumpy13458133st_umpy
stuns54719493st_u_ns
stunts65615253st_unts
stupa74112313st_upa_
stupes84116953st_upes
sturts63915143st_urts
subas74724073s__ubas
sumac99514883s__umac
sumacs105512103s__umacs
summas104313163s_ummas
sumos75720093s__umos
sumps95023433s__umps
sums65837583s__um_s
suras55336323s__uras
surfman1236203surfman
surimis938843surimis
surras65919533sur_ras
sutras64818583sutr__as
syrups11277953syru_ps
taramas9612693taramas
thrums11429123thrum_s
thujas1634433_thujas
thumbs13377443_thumbs
thumps13449353_thumps
thuyas1234773_thuyas
torulas759843torulas
tramps105114453_tramps
trams75327673_tram_s
trauma838803_trauma_
trims75021473_trim_s
tromps104911703_tromps
tronas63816893_tronas
truces84916333_truces
trucks124711973_trucks
trues54925323_tru_es
trugs65516803_tru_gs
trulls64110283_trulls
trumeau944163_trumeau
trump95615123_trum_p
trunks10429753_trunks
truss54916923_tru_ss
trusts64714433_trusts
truths9449503_truths
tryma1037223_tryma_
tubas75119573_t_ubas
tufas85314383_t_ufas
tumps95420793_t_umps
tunas54224123_t_unas

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 Limit1340272587.23318529.9
3Display Results2582580.0932774.2
 (SQL Overall)1786912587.48223882.8
 
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.