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

267 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
algoid8301147(None) 
algid75415581alg_id
valgoid1255211valgoid
alcid85817972al_cid
algin65718762alg_in
algor6513052algo_r
algors7312552algors
allod64418382allo_d
almond91410432almond
aloin55227422al_oin
aloud65018072al_oud
aroid65428342a_roid
avoid95516682a_void
haloid104317762hal_oid
loid55531492_l_oid
sloid64619712sl_oid
zygoid2045942zygoid
aboil72217543a_boil
abroad9310943abroad
acarid95017073acarid
acaroid103512313acaroid
accord1178843accord
acid77533393a__cid
acold86214923a_cold
acrid86920103a_crid
adenoid959253adenoid
adjoin14107293adjoin
adroit7518793adroit
aegis6316783aeg_is
afford1346493afford
afraid1049723afraid
again65218123a_gain
agamid103710693agamid
agatoid948623agatoid
aged67334253a_g_ed
aggie73415013a_ggie
agin56132713a_g_in
agio57828453a_g_io
agios65919863a_gios
aglow94711973aglo_w
ago48845523a_go__
agog68019003a_go_g
agon56531883a_go_n
agone65924553a_gone
agonic93515143a_gonic
agons66423783a_gons
agony96415653a_gony
agora6914333a_gora
agria65517143a_gria
ahold94714253a_hold
aid49269073a___id
aland65526413al_and
alanin6317273alanin
alated75625143alated
albeit8314343albeit
alcaic1039983alcaic
alcaide1088453alcaide
alcids94812293al_cids
alcove1178083alcove
alcoved1375613alcoved
aldol61212333aldo_l
aldols7109713aldols
aldose7311093aldose
aldrin7311243aldrin
alevin92511513alevin
alexia132910463alexia
alexin132311483alexin
alga57927603alg__a
algae65319623alg_ae
algal66518223alg_al
algas65624933alg_as
algicide1245563algicide
algins74816433algins
algorism1147353algorism
algum82711763alg_um
algums9208043algums
alibi7514233alibi_
alibied1038143alibied
alibis8311073alibis
alidad838883alidad
alif76242143al__if
aligned9128553aligned
alined75221403alined
aliped95414283aliped
alit46155693al__it
alkaloid1345293alkaloid
alkie95520033al_kie
alkoxide2083203alkoxide
alkoxy2033343alkoxy
alkyd13537093al_kyd
allied74217153allied
allodia8128793allodia
allods73615083allods
allot54933873allo_t
allots64019173allots
allow85420663allo_w
allowed111610073allowed
allows94517683allows
alloy85519973allo_y
alloyed11158033alloyed
alloys94014563alloys
almonds10127953almonds
almondy13144483almondy
almost81014433almost
almud84012183al_mud
alodia71112453alodia
aloe45540193al_o_e
aloes54933673al_oes
aloft8423433al_oft
aloha8513613al_oha
aloins65022203al_oins
alone55732963al_one
along65419493al_ong
aloof83521573al_oof
alow75328593al_o_w
also46423443also__
alto47831263alto__
altoist7313393altoist
altos55822953alto_s
alumin8513543alumin
ambroid1238883ambroid
ameboid1277233ameboid
amid77036353a__mid
amyloid1348543amyloid
android9311513android
aneroid8314003aneroid
angled84219083angled
angora71111573angora
anthoid11313313anthoid
aphid115515393a_phid
apod78123183a_po_d
aramid93315613aramid
argil65116883arg_il
argled85314553argled
argol65317263argo_l
argols74514613argols
argon65520593argo_n
argons75018203argons
argosy1036423argosy
argot67728653argo_t
argotic10310283argotic
argots74116033argots
argued84311173argued
arid57642713a__rid
arilloid946623arilloid
aroids75118223a_roids
askoi9507803askoi_
assoil688543assoil
augend837633augend
autoed7712823autoed
avid88325963a__vid
avoids104410203a_voids
azoic162912063a_zoic
blond85618373bl_ond
blood85319523bl_ood
blooie83913193blooie
cactoid12311033cactoid
ceboid11310653ceboid
clerid9312413clerid
clod76124613cl_o_d
cloud86716423cl_oud
colloid10312883colloid
conoid9818883conoid
cuboid1139503cuboid
cymoid1459473cymoid
deltoid938573deltoid
devoid1189363devoid
droid74218543_droid
elapid939543elapid
eloin55923203el_oin
factoid1338693factoid
flood95215603fl_ood
flooie93712153flooie
florid10311453florid
fluid94013963fl_uid
fluorid1136783fluorid
fucoid1237893fucoid
fulgid1137043fulg_id
fungoid1245253fungoid
gadoid9310463gadoid
ganoid8314443ganoid
geoid74215763_geoid
gid57047263__g_id
glenoid937803glenoid
globoid1145973globoid
goad66830983__goad
god57449793__go_d
gold65430163__gold
good66531803__good
gowd96519983__gowd
grid65829613__grid
guid66022823__guid
haemoid1337203haemoid
halid94424983hal__id
halloed113314913halloed
haloed104717603hal_oed
haloids113012553hal_oids
haploid1339833haploid
hemoid12313513hemoid
hyaloid1439073hyal_oid
hyoid12612443_hyoid
keloid11812623keloid
labroid1038823labroid
lagend838743lagend
lagged95520133lagged
lagoon7410483lagoon
laid56439143_l_aid
languid936623languid
lid47453513_l__id
lipid85916173_lipid
lipoid9411043lipoid
livid96714423_livid
load56730603_l_oad
logia68116603_logia
logic88217833_logic
login66025003_login
logoi69715943logoi_
loids66220703_l_oids
loin46838723_l_oin
looed64626133_looed
looie55624243_looie
lord55032083_l_ord
loud55228043_l_oud
lucid84314573_lucid
lurid64618973_lurid
mangold1137213mangold
mastoid10711233mastoid
mattoid1079283mattoid
meloid9616003meloid
mucoid1139783mucoid
myoid11512993_myoid
myxoid1936883myxoid
naevoid1194593naevoid
negroid9108893negroid
nevoid1098793nevoid
opioid9310083opioid
ovoid94811023_ovoid
pagod95013683pago_d
pallid93915283pal_lid
placid114012543placid
placoid1239773placoid
plaid85118303pl_aid
plod76723273pl_o_d
ploidy1237483pl_oidy
pygmoid1644533pygmoid
pyoid11513763_pyoid
rigid7913893rig_id
salmonid1147633salmonid
salpid9510883sal_pid
salvoed11307063salvoed
sarcoid10310453sarcoid
sialoid8310963sial_oid
sigmoid1146113sigmoid
slid55828983sl__id
sloids73712693sl_oids
slojd13378843sl_ojd
sloyd9409683sl_oyd
tabloid1048263tabloid
tangoed9318833tangoed
thalloid1246283thalloid
toroid7416013toroid
toxoid1438153toxoid
valid94618393val__id
viroid10411523viroid
void86220563__void
xyloid1738193xyloid
zooid15312103_zooid

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.1401276364.3
2DLD Change Limit1127162675.58020200.0
3Display Results2672670.0932871.0
 (SQL Overall)1786912675.81330739.9
 
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.