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

319 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
egoist761228(None) 
egoism977471egoism
egoists887071egoists
egotist8411271egotist
ageist7315382ageist
agist66325582ag_ist
agonist82615402agonist
egest65222342eg_est
egis56520652eg_is_
egoisms1065952egoisms
egoistic1147102egoistic
egos55821652ego_s_
egotism1038352egotism
egotists937062egotists
enlist6417042enlist
exist124618942e_xist
foist85730972_foist
gist56046762_g_ist
grist65529872_grist
hoist86433212_hoist
joist125125652_joist
legist71315252leg_ist
moist76033582_moist
oboist8312682oboist
aegis6316783aeg_is_
against838383against
ageism968803ageism
ageists848493ageists
aghast105711373aghast
agios65919863agios_
agism84614063ag_ism
agists75713173ag_ists
agonise83112693agonise
agonists9289833agonists
agons66423783agons_
agorot7415003agorot
aguish1059283aguish
alist56136783_alist
altoist7313393altoist
amorist9317643amorist
anoint6423633anoint
aorist64827873aorist
aroint6328153aroint
artist64125543artist
assist6314603assist
atomist92915763atomist
aurist65027253aurist
autist64324943autist
begirt9412683beg_irt
begot84625953bego__t
bemist105216953bemist
boast75935703_boast
bongoist1147643bongoist
boost75132473_boost
cellist9314423cellist
cist67244963__cist
coast75236273_coast
cost68057943_co_st
cubist104214443cubist
degust8310253deg_ust
deist64633593_deist
delist74625053delist
demonist11413463demonist
demotist11311843demotist
dentist8316743dentist
deposit10313003deposit
desist74818813desist
doest65829523_doest
doit56347853_doi_t
doits66223673_doits
dost57248353_do_st
droit65127123droi_t
droits74314313droits
easiest72318773easiest
east46659103e__ast
ebonise939613ebonise
ebons74316093ebons_
echoism1447363echoism
edgiest92310353edgiest
edict84722283e_dict
edit54934863e_di_t
edits65819033e_dits
eeliest73516473eeliest
eeriest73620673eeriest
egads74610923egads_
egers65120373egers_
egesta7428653eg_esta
egests74411253eg_ests
egging93210983egging
eggs66516153eg_gs_
egises7312493eg_ises
eglomise1143933eglomise
ego46726053ego___
egoless836983egoless
egotisms1146683egotisms
egotistic1246133egotistic
egress73310433egress
egret63327313eg_ret
egrets72712243egrets
eldest72912683eldest
elegist81311973elegist
elfish1267963elfish
elint55436473e_lint
elitist7414913elitist
elmiest9310743elmiest
eloign7456983eloign
eloin55923203eloi_n
eloins65419383eloins
elvish1277563elvish
emit65438423e_mi_t
emits75421473e_mits
encyst1136203encyst
engirt71112613engirt
english1137953english
enlists749393enlists
enokis103010273enokis_
enols54718403enols_
enosis63816423enosis
enows85115493enows_
entwist1048803entwist
envois988703envois_
eonism83213533eonism
eons46638713e_ons_
eosin55220923e_osin
epeeist938863epeeist
epos66723733epo_s_
ergot65422893ergo__t
ergotism1146273ergotism
ergots74512373ergots_
eros45238453ero_s_
erose55727273ero_se
erotism9312303erotism
erst47436433e__rst
etatist7415033etatist
etoile6312263etoile
etuis54013133etuis_
eugenist949623eugenist
eulogist949043eulogist
evict104417143e_vict
excise1538553excise
exists134710913e_xists
exit114428673e_xi_t
exits125515913e_xits
exons125813343exons_
exorcist1746873exorcist
exotism1638123exotism
exposit1649683exposit
feist86230073_feist
feudist1137573feudist
fist76248423__fist
florist10314243florist
foists95413983_foists
frost84727833fro_st
frowst125512073frowst
fuguist1136073fuguist
gainst74914693_gainst
gait56150193_gai_t
gaits65726013_gaits
gast56052563_g_ast
geest64829613_geest
genoise839423genoise
geoid74215763geoi_d
geoids8369843geoids
gest56149133_g_est
ghast95621223_ghast
ghis85020163_ghis_
ghost96318763_ghost
gift86735793_g_ift
gilt56348543_g_ilt
girt56646423_g_irt
gists66026193_g_ists
git46266053_g_i_t
gits55744593_g_its
glint66830183_glint
glost65422933_glost
gnomist1049133gnomist
goas55239943_goas_
goat56250833_go_at
goats65527303_goats
gobs76935573_gobs_
godet7530043_godet
gods65438043_gods_
goes55644093_goes_
going75218493_going
gooiest82813883gooiest
goos57644913_goos_
goose65925903_goose
goosy96018883_goosy
goriest82218743_goriest
gorse65926813_gorse
gorsy95915783_gorsy
gos47155133_go_s_
gosh86123423_go_sh
got49870443_go__t
gout56646003_go_ut
gouts64826173_gouts
goyish13379013_goyish
goys86328413_goys_
grift95924463_grift
griot65328413_griot
gript85126173_gript
grists74716483_grists
grit55247243_gri_t
grits65529583_grits
guest65225923_guest
guilt65125573_guilt
guise64717713_guise
gust55240703_g_ust
hedonist1249553hedonist
heist87030913_heist
heroism12311013heroism
hist76551543__hist
hoise85224773_hoise
hoists95516023_hoists
holist94723213holist
horst85833513_horst
host77852833_ho_st
hygeist1445793hygeist
insist6314513insist
ironist7314843ironist
jingoist16126263jingoist
joint125227723_joint
joists134711033_joists
joust125122293_joust
judoist1545633judoist
jurist134616393jurist
kist86540793__kist
kois85129403_kois_
leftist10279353leftist
legalist9512393legalist
leggiest10308233leggiest
legists899593leg_ists
legit61323503leg_i_t
legits71313003leg_its
list47055343__list
logiest82515543logiest
lookist1139563lookist
lost47951493_lo_st
lutist64317553lutist
lyrist9312293lyrist
maist75535683_maist
melodist1149743melodist
metrist9317063metrist
mist66154533__mist
monist84324983monist
most66554203_mo_st
neist54628443_neist
nepotist1059233nepotist
noise55723733_noise
noisy86813363_noisy
nudist73813323nudist
oast47156323__oast
oboists937903oboists
odist6421913_odist
ogrish1039263ogrish
ogrism937913ogrism
ologist8313833ologist
oust46747443__oust
papist102618743papist
persist9315853persist
point75338733_point
pois66539043_pois_
poise75127893_poise
poloist91016323poloist
posit75833333_posit
post67953363_po_st
prosit85124593prosit
prost75434103pro_st
protist9320223protist
purist85525053purist
quoit143819863quoi_t
quoits15379683quoits
racist82822793racist
rapist82520673rapist
realist73225383realist
regilt71217493reg_ilt
relist64628413relist
reposit9315863reposit
resist64524533resist
retwist1039483retwist
revuist1038473revuist
rigorist949123rigorist
roast56230143_roast
roost55730933_roost
roust55532063_roust
sadist74221353sadist
schist11312653schist
segos64919483sego_s_
sexist133013483sexist
shist84829613_shist
soloist7915893soloist
spoilt85016593spoilt
sumoist9311613sumoist
tanist6324593tanist
tennist72813113tennist
tenorist8413023tenorist
theist9314763theist
toast55831013_toast
toit46353063_toi_t
toits55327473_toits
tost48351923_to_st
trois57226093trois_
tubist83013163tubist
twist86820983_twist
typist1139823typist
ugliest8410153ugliest
utopist938693utopist
vegetist1257393vegetist
verist93823893verist
vibist11610583vibist
violist10312143violist
waist86132383_waist
whist115322953_whist
wist78049293__wist
worst86330133_worst
wost76544363_wo_st
wrist84827563_wrist
yogis95617743yogis_
zooiest16199923zooiest

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.1231452772.4
2DLD Change Limit1127163195.64019985.1
3Display Results3193190.0963322.9
 (SQL Overall)1786913195.85930498.5
 
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.