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

148 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
elegant831150(None) 
elegance1146372elegance
elegancy1444382elegancy
elegantly1343982elegantly
elegist81311972elegist
elegit71212892eleg_it
element9317802element
elephant1347552elephant
eluant6315092el_uant
inelegant1045242inelegant
leant56737782_le_ant
levant9314492_levant
relevant1149242relevant
abeyant1248083abeyant
alant55742293al__ant
alegar739283alega_r
alegars838933alegars
allegiant1047263allegiant
alterant8614963alterant
began86319573_began_
begat86629723_bega_t
beleapt11310253bele_apt
bezant17814543_bezant
blatant9310673blatant
bleat75737003ble_a_t
blent76230953ble__nt
celebrant1347013celebrant
clamant11312433clamant
clean75420413cle_an_
cleans85817053cle_ans
cleat76335063cle_a_t
clement11313773clement
decant93524223_decant
delegacy1543533delegacy
delegate10410463delegate
elan46734243el__an_
eland65820393el__and
elans55527753el__ans
elect74327033ele__ct
elegances1246183elegances
elegiac1045453elegiac
elegiacs1144053elegiacs
elegies81312903elegies
elegise8139393elegise
elegists9128113elegists
elegits8149343elegits
elegize17127383elegize
elegy939303eleg__y
elements10312173elements
elephants1444803elephants
elevate101110373elevate
eleven988303eleven_
elevens1066803elevens
eleventh1443773eleventh
elevon977953elevon_
elevons1067573elevons
elint55436473el__int
eluants737583el_uants
eluent6315483el_uent
emanant9411083emanant
emergent1149113emergent
emigrant1148553emigrant
enchant12313113enchant
entrant7318873entrant
errant6618733e_rrant
etchant1249813etchant
event85924443eve__nt
exeunt1338703exe_unt
exigent1539513exigent
explant16310133explant
exsecant1794753exsecant
extant132714753e_xtant
flagrant1247633flagrant
gelant72821673_gelant
gellant83214053gel_lant
glean65818203gle_an_
gleans75014743gle_ans
iterant7317783iterant
lagan66520343_lagan_
lagans75717783_lagans
lean46345243_le_an_
leans55536253_le_ans
leapt75027473_le_apt
learnt64019253_learnt
least56134883_le_ast
legacy1256653_legacy
legal65715943_lega_l
legals73412733_legals
legate72917453_legate
legato72810953_legato
legend837693_legend
legist71315253_legist
legit61323503_leg_it
legman949653_legman_
legong836963_legong
leman75622603_leman_
lemans85316393_lemans
lent46360533_le__nt
levants1037723_levants
ligan67920283_ligan_
ligand85011293_ligand
ligans76817733_ligans
logan68123283_logan_
logans76319063_logans
meant76537213_me_ant
operant9317223operant
oregano846253oregano
pageant10312783pageant
pedant9319493_pedant
plant75437113pl__ant
pleasant1048323pleasant
pleat74734473ple_a_t
pliant83918823pl_iant
pregnant1149883pregnant
rebegan1045953rebegan_
recant83228683_recant
regent74127673_regent
regnant8312843_regnant
regrant8317323_regrant
relaxant1545843relaxant
relearnt849213relearnt
relegate9311243relegate
relent64431853rele__nt
reliant7319243rel_iant
revenant11410273revenant
secant84023293_secant
segregant1144363segregant
sejant133114483_sejant
sejeant1489723seje_ant
sergeant9129403sergeant
setenant849923setenant
slant55238703sl__ant
slogan7539223slogan_
slogans8407983slogans
taggant9310223taggant
telecast1048293telecast
telega736773telega__
telegas837443telega_s
telegony1244223telegony
teleman959573teleman_
teleran7510173teleran_
telerans859473telerans
tenant6322473_tenant
tolerant8411463tolerant
ululant747693ululant
vegan95114153_vegan_
vegans103910853_vegans
vegetant1246963vegetant

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 Limit1340271486.81319672.2
3Display Results1481480.0463217.4
 (SQL Overall)1786911487.26524596.1
 
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.