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

141 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
elegist8131197(None) 
elegise8139391elegise
elegists9128111elegists
elegit71212891elegi_t
elegits8149341elegits
legist71315251_legist
elegant8311502elegant
elegiac1045452elegiac
elegies81312902elegies
elegised10145922elegised
elegises9128822elegises
elegize17127382elegize
elemis8312382elemis_
elitist7414912elitist
epeeist938862epeeist
eulogist949042eulogist
legists899592_legists
legit61323502_legi_t
legits71313002_legits
ologist8313832ologist
plenist9314332plenist
ableist9311773able_ist
aegis6316783_aegis_
ageist7315383age_ist
agist66325583__agist
alienist8411993alienist
alist56136783al__ist
allergist1046843allergist
altoist7313393altoist
begirt9412683_begirt
bemist105216963_bemist
blemish1436603blemish
blest76431723ble__st
cellist9314423cel_list
chemist143615003chemist
cladist10311973cladist
clerisy1246823clerisy
clevis1158963clevis_
coexist1638583coexist
degust8310253_degust
deist64633593_de_ist
delist74625053_delist
desist74818813_desist
duelist8511413duelist
ecesis84611203ecesis_
ecologist12314143ecologist
edgiest92310353e_dgiest
eeliest73516473eeliest
eeriest73620673e_eriest
egest65222343__egest
egis56520653__egis_
egoist7612283e_goist
egotist8411273egotist
eldest72912683el_dest
elect74327033ele__ct
elects83315003elects_
elegiacs1144053elegiacs
elegising1145423elegising
elegized19145683elegized
elegizes18137103elegizes
elegy939303eleg__y
element9317803element
elemi7312503elemi__
elfish1267963el_fish
elicit8417203elici_t
elicits9311233elicits
elint55436473el__int
elitism939763elitism
elitists848543elitists
elmiest9310743elmiest
elvish1277563el_vish
emesis84712623emesis_
energise947333energise
engirt71112613e_ngirt
enlist6417043e_nlist
enologist10314123enologist
entwist1048803entwist
epeeists1044793epeeists
etatist7415033etatist
eugenist949623eugenist
eulogise945643eulogise
eulogists1046653eulogists
evenest10312103evenest
exegetist1744873exegetist
exist124618943__exist
eyelift1396383eyelift
feist86230073_fe_ist
fledgiest1444183fledgiest
flemish1536373flemish
florist10314243florist
flutist102910783flutist
geologist11611783geologist
gist56046763___gist
heist87030913_he_ist
hygeist1445793hygeist
imagist1077333imagist
least56134883_le_ast
ledgiest10288593ledgiest
leeriest83112883leeriest
leftist10279353leftist
legalist9512393_legalist
leges64427293_leges_
leggiest10308233leggiest
legion75712983_legion
legs56133693_leg_s_
leis45739603_le_is_
lenis56326863_lenis_
lest46956323_le__st
levis85818553_levis_
lewis85315843_lewis_
lexis125916033_lexis_
list47055343_l__ist
logiest82515543_logiest
lutist64317553_lutist
lyrist9312293_lyrist
melanist10313053melanist
melodist1149743melodist
neist54628443_ne_ist
neologist10712813neologist
ologists939443ologists
oologist9313493oologist
pietist9414033pietist
plenish1239943plenish
plenism11310113plenism
plenists1038253plenists
polemist12412363polemist
querist16311133querist
regilt71217493_regilt
relist64628413_relist
resist64524533_resist
sexist133013483_sexist
sleight11279023sleight
solecist10910783solecist
telecast1048303telecast
telegas837443telegas_
teleost7410523tele_ost
telesis7310793telesis_
televise1146063televise
theist9314763the_ist
vegetist1257393vegetist
verist93823893_verist

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.406440125.6
2DLD Change Limit1340271416.95319276.1
3Display Results1411410.0632238.1
 (SQL Overall)1786911417.42224075.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.