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

306 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
thujas163443(None) 
thuja1535211thuja_
thuyas1234771thuyas
chufas14397672chufas
hulas84920882_hulas
pujas145513322_pujas
thetas93011572thetas
thuds95110132thu_ds
thugs95611992thu_gs
thulias1035742thulias
thumbs13377442thumbs
thumps13449352thumps
thunks13459032thunks
thurls9418712thurls
thus76721472thu__s
thuya1135582thuya_
tubas75119582t_ubas
tufas85314382t_ufas
tunas54224122t_unas
ajugas1435263ajugas
aquas142412613aqu_as
auras55932563_auras
bhuts105812953bhu_ts
bunas75126573_bunas
buras74736303_buras
charas114223613charas
chelas113817203chelas
chias104625523ch_ias
chicas135916473chicas
chinas115119403chinas
cholas114818003cholas
chubs125412623chu_bs
chucks174812933chucks
chufa13489113chufa_
chuffs17427783chuffs
chugs115511943chu_gs
chukar1534633chukar
chukars1634283chukars
chukkas1532783chukkas
chumps154313823chumps
chums125015833chu_ms
chunks154210333chunks
chuppas1644123chuppas
churls115411073churls
churns114910233churns
churrs115111513churrs
chutes114615773chutes
dhurnas1153443dhurnas
dhutis1035943dhutis
doulas75114993doulas
doumas95314813doumas
douras75016723douras
dumas85420433_dumas
duras65727733_duras
faunas94013633faunas
fujis15379243_fujis
ganjas14149113ganjas
hahas117118443_hahas
hajes155420943_hajes
hajis156716283_hajis
has67372653_h__as
hijab1736803_hijab
hijabs1833083_hijabs
hijras1635773_hijras
horas86333103_horas
hoyas115016163_hoyas
hubs96027143_hu_bs
hucks144322173_hucks
hues75235233_hu_es
huffs144514743_huffs
hugs86129753_hu_gs
hula74923753_hula_
hulks125715483_hulks
hulls84923563_hulls
human102716033_human
humans112312433_humans
humps126322803_humps
hums96831423_hu_ms
humus106215073_humus
hunks125321453_hunks
huns76136933_hu_ns
hunts86826173_hunts
hurds95219073_hurds
hurls86522713_hurls
hurts86922823_hurts
husks125015453_husks
huts76737443_hu_ts
huzzas1735863_huzzas
hylas114815903_hylas
jubas144614223_jubas
judas134911883_judas
jujus11347463_jujus
kahunas1473953kahunas
khedas1446313khedas
lauras63414333lauras
lehuas935943lehu_as
loumas84812333loumas
lumas75622913_lumas
lunas55025013_lunas
muras75329583_muras
ninjas1386303ninjas
ohias84415573oh_ias
phuts104613503phu_ts
puja135714923_puja_
pujah17478543_pujah
pujahs18404943_pujahs
pumas95121563_pumas
punas74826753_punas
pupas95219283_pupas
rajas127317723_rajas
rheas84816953rh_eas
rhumbas14305163rhumbas
rhumbs13366773rhumbs
rhus75114053rhu__s
rhuses94911793rhuses
riojas1335813riojas
saunas63915433saunas
scubas103710223scubas
shamas113717943shamas
sheas86331793sh_eas
shivas124512413shivas
shojis16348493shojis
shucks154010413shucks
shuls85319713shu_ls
shuns85018143shu_ns
shunts95712023shunts
shutes93518223shutes
shuts85622483shu_ts
shwas116415103sh_was
skuas95611733sku_as
sojas124716393_sojas
strumas9419833strumas
stupas83910883stupas
subas74724083_subas
suras55336333_suras
tablas83716163tablas
tafias93111963tafias
taigas73712573taigas
tajes124920693t_ajes
takas95520683t_akas
talas55935893t_alas
talukas11316213talukas
tankas104613773tankas
tapas74627713t_apas
tas38477103t___as
taunts65715663taunts
tauons63412673tauons
taupes8212673taupes
taus46342733tau__s
tauts56125513tau_ts
tazzas1436283tazzas
teas45851493t__eas
teguas768013teguas
tenias64720073tenias
tepas76521683t_epas
terras63516973terras
teslas64212173teslas
tetras63017623tetras
texas126514933t_exas
thacks154311923thacks
thae76825563th__ae
than76128773th__an
thanes94918983thanes
thanks134313133thanks
tharms115712243tharms
that75639323th__at
thaw107521313th__aw
thaws116515463th_aws
thebes115914493thebes
theca103311453theca_
thecae11299653thecae
thecal113310313thecal
thefts12387923thefts
thegns10547433thegns
theins95015423theins
theirs94610353theirs
themes115319253themes
thenal92712433thenal
thenar92610003thenar
thenars10248523thenars
thens85921833th_ens
theres96525473theres
therms115914873therms
theses96517973theses
thesis94913733thesis
thesps11448263thesps
theta83414573theta_
thews117416193th_ews
thicks154511993thicks
thighs1346633thighs
thills95515383thills
things104914303things
thinks134613363thinks
thins85826333th_ins
thiols95112763thiols
thiram1139963thiram
thirams1236823thirams
thirds10438603thirds
thirls95012063thirls
this76027383th__is
tholes94919783tholes
tholos94213003tholos
thongs104611193thongs
thorax1638253thorax
thorias102312053thorias
thorns95314103thorns
thorps113610893thorps
thous86017263th_ous
thrash12258363th_rash
thraw1110515923th_raw
thraws129211103thraws
thread105011093thread
threads11419953threads
threap11569663threap
threaps12488643threaps
threat95020463threat
threats104311683threats
threes97117323threes
thrips11299013thrips
throat94819753throat
throats104612193throats
throbs118311373throbs
throes97518673throes
throws129715233throws
thrums11429123thrums
thrusts10226523thrusts
thruway1643163thruway
thruways1742503thruways
thud85613913thu__d
thug86415483thu__g
thulia936113thulia
thumb124511283thu_mb
thump126211573thu_mp
thunk124911853thu_nk
thurl84912683thu_rl
thusly1235133thusly
thymes144810743thymes
thymus14324743thymus
tiaras6314553tiaras
tibias839953tibias
tikkas934533tikkas
tineas64616483tineas
toeas55726423t_oeas
togas67823003t_ogas
tolas54532773t_olas
tongas74315533tongas
toras55540373t_oras
tortas64918253tortas
torulas759853torulas
toucan838193toucan
toucans937583toucans
toughs105414993toughs
tours55325893tou_rs
touses64229673touses
touts54830393tou_ts
traumas938593traumas
tronas63816903tronas
truces84916333truces
trucks124711973trucks
trues54925323tru_es
trugs65516803tru_gs
trulls64110283trulls
trumps104611883trumps
trunks10429753trunks
truss54916923tru_ss
trusts64714433trusts
truths9449503truths
tsuba745563tsuba_
tsuris62710203tsuris
tuba65422363t_uba_
tubae74716643t_ubae
tubal75517203t_ubal
tubes74826453t_ubes
tubs65430063t_u_bs
tucks114721123t_ucks
tufa75016613t_ufa_
tuffs115118263t_uffs
tufts85713273t_ufts
tugs56231673t_u_gs
tuis44829643t_u_is
tules54532793t_ules
tumps95420793t_umps
tuna45127843t_una_
tunes55332193t_unes
tungs65520633t_ungs
tuns45138663t_u_ns
tups65628763t_u_ps
turds65021693t_urds
turfs84620443t_urfs
turks95320823t_urks
turns55623243t_urns
turps74918733t_urps
tusks94915533t_usks
tuts45838453t_u_ts
tutus55214813t_utus
tuxes124316043t_uxes
twas76824083t__was
tzuris15286913tzuris
upas68322383__upas
utas45924953__utas
uvulas946523uvulas
whenas124610463whenas
whumps16427093whumps
whups134210003whu_ps
yucas106013913_yucas
yugas95012063_yugas

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127163064.67324120.7
3Display Results3063060.0933290.3
 (SQL Overall)1786913065.13934771.6
 
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.