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

199 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
elegits814934(None) 
elegies81312901elegies
elegist81311971elegist
elegists9128111elegists
elegit71212891elegit_
legits71313001_legits
elects83315002ele_cts
elegiac1045452elegiac
elegiacs1144052elegiacs
elegise8139392elegise
elegises9128822elegises
elegize17127382elegize
elegizes18137102elegizes
elemis8312382elemi_s
elicits9311232elicits
legist71315252_legist
legists899592_legists
legit61323502_legit_
aegis6316783_aegi_s
alegars838933alegars
alerts64418223ale_rts
alevins102110573alevins
alexias14249793alexias
alexins141910663alexins
algins74816433al_gins
alights113211433alights
befits114711503_befits
begets96215523_begets
begins94415303_begins
benefits1345713benefits
bleats85518613ble_ats
blets75324943ble__ts
blights133110213blights
celeries10316313celeries
celerity1347643celerity
cleats84919313cle_ats
clefts114610163cle_fts
clergies1137903clergies
clerics1149333clerics
clerids1049093clerids
clevis1158963clevi_s
coedits10310243coedits
credits1039973credits
debits94214503_debits
deceits102810883dece_its
delegate10410463delegate
delegates1139843delegates
delights1347333delights
delimits1137573delimits
demerits11310763demerits
demits94918073_demits
digits84114533_digits
ecesis84611203ecesi_s
eclogite1146303eclogite
eclogites1245263eclogites
edits65819033__edits
egests74411253ege_sts
egis56520653__egi_s
eights103618983e_ights
ejects15409953eje_cts
elains64919853el_ains
elapids1036503elapids
elect74327033ele_ct_
elegant8311503elegant
elegised10145923elegised
elegized19145683elegized
elegy939303eleg__y
elements10312173elements
elemi7312503elemi__
elevate101110373elevate
elevates111110423elevates
elevens1066803elevens
elevons1067573elevons
elfins94810943el_fins
elicit8417203elicit_
elints65816423el_ints
elite56230183el__ite
elites66027123el__ites
elitist7414913elitist
elitists848543elitists
elixirs1443543elixirs
eloigns8425353eloigns
eloins65419383el_oins
eluants737583eluants
eluents738703eluents
emeries91620023emeries
emerita938713emerita
emeritas1046433emeritas
emeriti949433emeriti
emeritus1045173emeritus
emesis84712623emesi_s
emetics11610723emetics
emetins9812653emetins
emits75421473__emits
enemies9313693enemies
energids1045583energids
energies9310783energies
epeeist938863epeeist
epeeists1044793epeeists
erects84116183ere_cts
eremite9312833eremite
eremites10312603eremites
ergots74512373e_rgots
esprits938393esprits
eulogias946553eulogias
eulogies938523eulogies
eulogist949043eulogist
eulogists1046653eulogists
events94814073eve_nts
everts94514893eve_rts
exegete1545773exegete
exegetes1655313exegetes
exempts1844023exempts
exerts133712293exe_rts
exits125515913__exits
eyelets1057523eyelets
eyelids1135943eyelids
eyelifts1462753eyelifts
fleapits1363253fleapits
fleets96915063fle_ets
flights143310983flights
flits85625223fl__its
gits55744593___gits
gleets75315053gle_ets
ileitis738063ile_itis
klephts1642183klephts
leasts64616413_leasts
leets54927123_le_ets
lefts86517813_le_fts
legals73412733_legals
legate72917453_legate
legates82917683_legates
legato72810953_legato
legatos82711183_legatos
legers74518313_legers
leges64427293_leg_es
leggins9259473leggins
legion75712983_legion
legions84611783_legions
legs56133693_leg__s
leis45739603_le_i_s
lenis56326863_leni_s
lenite6719983_lenite
lenites7818443_lenites
lenity9612713_lenity
lets47147943_le__ts
levies93919863_levies
levins94514653_levins
levis85818553_levi_s
levity1277903_levity
lewis85315843_lewi_s
lexis125916033_lexi_s
lights104519913_lights
limits82514143_limits
lits46252493_l__its
logics95711123_logics
logins77820643_logins
merits8320873_merits
olefins1037493olefins
oleins6313523ole_ins
ologies8615023ologies
ologist8313833ologist
ologists939443ologists
peewits12105873peewits
pelagics1345553pelagics
pewits112810683_pewits
plaits83816473pl_aits
pleats85218593ple_ats
pledgets12365673pledgets
plenist9314333plenist
plenists1038253plenists
plights13299313plights
rebegins1136003rebegins
recits83621353_recits
reedits8511743reedits
reemits9611303reemits
refits94017653_refits
regius7311923_regius
relegate9311243relegate
relegates10310943relegates
relents74018503rele_nts
relets64025673rele__ts
relights1248053relights
remits85622943_remits
resits64725563_resits
selects91912143sele_cts
selenite81713113selenite
selenites91312093selenites
sleets64318873sle_ets
sleighs11245673sleighs
sleights12275913sleights
slights112810723slights
slits56128853sl__its
telegas837443teleg_as
teleosts846423teleosts
telesis7310793telesi_s
ulexite1445723ulexite
ulexites1534943ulexites
vegies104314273_vegies

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.390458182.1
2DLD Change Limit1340271996.55020462.1
3Display Results1991990.0603316.7
 (SQL Overall)1786911997.00025527.3
 
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.