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

516 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
theist931476(None) 
atheist10314051atheist
heist87030911_heist
theism1139481theism
theists1039141theists
ageist7315382ageist
atheism1248522atheism
atheists1138702atheists
chemist143615002chemist
chest104926142che_st
deist64633592_deist
ditheist1249492ditheist
feist86230072_feist
heists96814632_heists
hest75950772_he_st
hist76551542_h_ist
hoist86433212_hoist
neist54628442_neist
shiest95821522shiest
shist84829602sh_ist
tanist6324592tanist
test48651622t_e_st
theft114118132the_ft
thefts12387922thefts
thein85919022thei_n
theine94814922theine
theins95015422theins
their85512152thei_r
theirs94610352theirs
theisms1237762theisms
theistic1348152theistic
thens85921832thens_
theorist1149552theorist
these86519012the_se
thesis94913732thesis
thesp105410312the_sp
thewiest14196342thewiest
thews117416192thews_
thirst9312252thirst
this76027382th_is_
thrift12412042thrift
thrust91911892thrust
tubist83013162tubist
twist86820982t_wist
typist1139822typist
whist115322952wh_ist
ableist9311773ableist
achiest12315183achiest
ageism968803ageism
ageists848493ageists
agist66325583_agist
ahis76135383ah_is_
alist56136783_alist
anenst63514983anenst
aorist64827873aorist
artist64125543artist
ashiest10313953ashiest
assist6314603assist
atavist10311093atavist
atheisms1346913atheisms
atheistic1447333atheistic
athirst1037873athirst
atomist92915763atomist
attest62618613atte_st
aurist65027253aurist
autist64324943autist
beast76338643_beast
behest11314613behest
bemist105216953bemist
best66355323_be_st
bheesty1542493bheesty
blest76431723ble_st
breast8319633breast
chais107530313chais_
chaise114916413chaise
cheat105732453che_at
cheats114519543cheats
cheese113812763cheese
cheesy14419193cheesy
chefs136214663chefs_
chemise143211503chemise
chemism16339303chemism
chemists152710323chemists
cherish15310463cherish
chert105232103che_rt
cherts115617233cherts
chess105016923che_ss
chests114916263che_sts
chesty144610503che_sty
cheviot1546933cheviot
chewiest16177293chewiest
chews135418513chews_
chis95933313ch_is_
chit96937463ch_i_t
chits105424573ch_its
chrism13710673chrism
christy1536623christy
chutist1239453chutist
chymist17268173chymist
cist67244963__cist
coexist1638583coexist
crest74632693cre_st
cubist104214443cubist
deism84116033_deism
deists74916433_deists
delist74625053delist
desist74818813desist
ditheism1446053ditheism
ditheists1345563ditheists
doest65829523doe_st
drest65530343dre_st
driest74722753driest
duelist8511413duelist
east46659103__east
egest65222343ege_st
egoist7612283egoist
elegist81311973elegist
enlist6417043enlist
epeeist938863epeeist
erst47436433__erst
etatist7415033etatist
etherish1448273etherish
ethers94518413ethers_
ethicist1347893ethicist
euthenist1249033euthenist
exist124618943_exist
feast85932723_feast
feint84732253_feint
feists94915313_feists
feisty12449293_feisty
fest74949443_fe_st
fideist1139753fideist
fist76248423__fist
fliest94718423fliest
foist85730973_foist
freest95318283freest
geest64829613_geest
gest56149133_ge_st
ghast95621223gh_ast
ghees95215553ghees_
ghis85020163gh_is_
ghost96318763gh_ost
gist56046763__gist
gneiss765953gneiss
grist65529873_grist
guest65225923gue_st
hadst93220223_hadst
haint85436323_haint
hast76259483_h_ast
heart85440743_heart
heat77061423_he_at
heats85838403_heats
heft106736293_he_ft
hefts116218153_hefts
hehs106723963_hehs_
heigh124812543_heigh
height134713433_height
heil76328933_hei_l
heils85222193_heils
heir77523803_hei_r
heirs85618563_heirs
heishi1235843_heishi
heisted113210653_heisted
heister103613623_heister
heliast10312073_heliast
helot85332683_helot
hems95534943_hems_
hens75642573_hens_
hent76656383_he_nt
hents87330743_hents
heriot9422343_heriot
hers75844873_hers_
hes66654203_he_s_
hests85829933_he_sts
het67674313_he__t
hets75547203_hets_
hews105631573_hews_
hies74842833_hies_
hilt75850713_h_ilt
hint77455743_h_int
his66359503_h_is_
hisn79620933_h_isn
hiss75629213_h_iss
hists86328373_h_ists
hit66569193_h_i_t
hits75545133_h_its
hoise85224773_hoise
hoists95516023_hoists
holist94723213holist
horst85833513_horst
host77852833_h_ost
hurst85527193_hurst
hygeist1445793hygeist
iciest82914743iciest
insist6314513insist
itchiest1336523itchiest
jest116738503_je_st
joist125125653_joist
jurist134616393jurist
khet116328623khe__t
khets124913433khets_
khis117017983kh_is_
kist86540793__kist
lathiest11312653lathiest
least56134883_least
legist71315253legist
leis45739603_leis_
lest46956323_le_st
list47055343__list
lithest10513913lithe_st
lutist64317553lutist
lweis8458693lweis_
lyrist9312293lyrist
maist75535683_maist
mist66154533__mist
moist76033583_moist
monist84324983monist
mothiest13311033mothiest
mythiest1636033mythiest
nest45548733_ne_st
nontheist1248313nontheist
nudist73813323nudist
oboist8312683oboist
odist6421913_odist
others93918003others_
pantheist1449153pantheist
papist102618743papist
peise75825773_peise
pest65555293_pe_st
phis95724903ph_is_
pietist9414033pietist
pithiest132711443pithiest
plenist9314333plenist
prest75736353pre_st
priest84125423priest
purist85525053purist
querist16311133querist
quest144121323que_st
racist82822793racist
rapist82520673rapist
reest54938093_reest
reis45343233_reis_
relist64628413relist
resist64524533resist
resit54241043_resit
rest46459843_re_st
rheas84816953rheas_
sadist74221353sadist
schist11312653schist
seis45542393_seis_
seise54727853_seise
seism75019023_seism
sexist133013483sexist
sheas86331793sheas_
sheds96122703sheds_
sheesh1237813sheesh
sheet84836953she_et
sheets93918493sheets
sheik122514653shei_k
sheikh16206993sheikh
sheiks132510013sheiks
sheila969843sheila
shent85933493she_nt
shes75734353she_s_
shews115924713shews_
shies86136553shies_
shift114225133sh_ift
shirt84533893sh_irt
shists96515103sh_ists
shit76745933sh_i_t
shits84731163sh_its
shrift12413543shrift
shris84221443shris_
shyest125511833shyest
sliest66621943sliest
speise84614253speise
speiss84311643speiss
statist7317723statist
stylist102110283stylist
tachist12613293tachist
tacit76333673taci_t
taels56822073taels_
taint55542283t_aint
tamest85721293tamest
tamis76728723tamis_
tanists7313653tanists
tapis75028863tapis_
taxis126821973taxis_
teas45851493t_eas_
tease55428713t_ease
teat45963633t_e_at
teats55636813t_eats
techiest1359833techiest
teds54932573t_eds_
teeing73916973teeing
teels55726373teels_
teems76019783teems_
teeniest82112413teeniest
teens56227483teens_
teensy9478273teensy
tees45353583t_ees_
tegs56031493t_egs_
teiid6312533t_eiid
teind6213613t_eind
teleost7410523teleost
tels46841693t_els_
tempt95124843t_empt
tenet55542213t_enet
tennist72813113tennist
tens45647413t_ens_
tense55225843t_ense
tent46159863t_e_nt
tents56434213t_ents
terse55026823t_erse
testa54822043t_e_sta
tests56530193t_e_sts
testy85419063t_e_sty
tet39274983t_e__t
tets45847453t_ets_
tews76431643t_ews_
text116033933t_e_xt
texts125515043t_exts
thairm1156963thairm
that75639323th__at
thaws116515463thaws_
the67436053the___
thebe107515433the_be
thebes115914493thebes
theca103311453the_ca
thecae11299653thecae
thecal113310303thecal
thecate123210023thecate
thee78039063the__e
thegn95810903the_gn
thegns10547433thegns
theines104013233theines
them97427043the__m
theme105921733the_me
themed125912583themed
themes115319253themes
theming133610473theming
then78429693the__n
thenal92712413thenal
thenar9269993thenar
thence112010843thence
theorise1137873theorise
theorists1246593theorists
theory121098353theory
therapist1447073therapist
there87527393the_re
thereat104315243thereat
theres96525473theres
thereto1038993thereto
theriac1239143theriac
therian10311293therian
therm106018023the_rm
therme115814993therme
thermit12312003thermit
thermits1338493thermits
therms115914873therms
theses96517973theses
thesps11448263thesps
theta83414573the_ta
thetas93011573thetas
thetic11412883thetic
theurgist1343163theurgist
thew108226233the__w
thewier1336063thewier
thewy146311853the_wy
they107223753the__y
thick145613353th_ick
thief114516303th_ief
thieve1235963thieve
thievish1743253thievish
thigh12410113th_igh
thill85918733th_ill
thin76732383th_i_n
thine85026853th_ine
thing96622963th_ing
think125018793th_ink
thins85826323th_ins
thio77225413th_i_o
thiol87616043th_iol
thir76420543th_i_r
third95912493th_ird
thirl85416823th_irl
thirsts1036243thirsts
thirsty1354083thirsty
thirty12378403th_irty
thistle10107803th_istle
thistly1395963th_istly
those85218143th_ose
thous86017253thous_
thrash12258353thrash
threat95020463threat
threats104311673threats
threes97117323threes_
thresh12276863thresh
thrice114311573thrice
thrifts1335523thrifts
thrifty1634193thrifty
thrill94910593thrill
thrip103012183thri_p
thrips11299013thrips
thrive125313223thrive
throat94819753throat
thrush12257483thrush
thrusts10226523thrusts
thuds95110133thuds_
thugs95611993thugs_
thus76721473th_us_
thwart12311683thwart
thymiest1634733thymiest
thyrse1235133thyrse
thyrsi1234453thyrsi
tidiest83514873tidiest
tieing73518763tieing
tiers55526523tiers_
ties45248313tie_s_
tikis95615973tikis_
tilt46252423t__ilt
tiniest73020123tiniest
tint46758863t__int
tipis76019923tipis_
tis37056643t__is_
tit36771043t__i_t
titis56023813titis_
titlist7312923titlist
tits46145033t__its
tmesis8529793tmesis
toast55831013t_oast
toeas55726423toeas_
toeing74418473toeing
toes46956443toe_s_
toit46353063t_oi_t
toits55327473t_oits
toniest73218903toniest
tonish93415903tonish
topis76025833topis_
tost48351923t__ost
totemist1049033totemist
tourist7313203tourist
toyish122911123toyish
trait56940843trai_t
traits65121983traits
treat56240353tre_at
treats64821693treats
trees55835763trees_
treks96016853treks_
tres46542903tre_s_
tress55423163tre_ss
tressy9448553tressy
tret46653533tre__t
trets55928023trets_
trevet94818913trevet
trews86118893trews_
treys85018213treys_
tries55742813tries_
triste63818643t_riste
tritheist1247203tritheist
trois57226093trois_
truest64816193truest
truism8118623truism
trust55426853t_rust
tryst84716223t_ryst
tsarist7712253tsarist
tsetse664693tsetse
tubaist938703tubaist
tubists9288323tubists
tuis44829643t_uis_
turista737443turista
tweet84823983twe_et
tweets94210103tweets
twists9549753t_wists
twisty12426863t_wisty
twit76329063t_wi_t
twits86015793t_wits
twixt155512483t_wixt
tyees86019453tyees_
tyers86220053tyers_
tyes76433373tye_s_
typiest1238203typiest
typists1236173typists
tzarist1659103tzarist
utopist938693utopist
verist93823893verist
verst84429373_verst
vest75743603_ve_st
vibist11610583vibist
waist86132383_waist
weest85026773_weest
west75748083_we_st
wheat114924573whe_at
wheats125013223wheats
whens114618763whens_
whet105133783whe__t
whets115019613whets_
whews145114493whews_
wheyish1944063wheyish
wheys145911553wheys_
whilst1239143whilst
whipt135317423wh_ipt
whish144512923wh_ish
whisht154510813wh_isht
whisk154510143wh_isk
whists124613813wh_ists
whit104834173wh_i_t
whits115923823wh_its
wist78049293__wist
withiest142411243withiest
wrest84925433wre_st
wriest94419713wriest
wrist84827563_wrist
yeast85327943_yeast
zest136035703_ze_st
zitherist2146593zitherist

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 Filter1786911127160.1731032896.0
2DLD Change Limit1127165165.79619447.2
3Display Results5165160.1533372.5
 (SQL Overall)1786915166.12229188.3
 
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.