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

213 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
lexeme153649(None) 
lexemes1635671lexemes
legume936912legume
levee84023812leve_e
lexemic1844282lexemic
lexes127225262lexe_s
sememe10129982sememe
taxeme1536252taxeme
alexine142410543alexine
axemen1547493_axemen
became123213163became
become123312593become
bedemen12910183bedemen
bename103316073bename
berime105317333berime
berme96022943be_rme
beseem1069083beseem
betime105914833betime
bireme10310143bireme
cleome1039083cle_ome
creme94319323_creme
deem75432893de_em_
deemed104713063de_emed
deems85421773de_ems
defame123212433defame
degame102713183degame
delete73620703delete
delime9314043delime
deme76536283__deme
dexes135224513dexe_s
dexie134716893dex_ie
edema8610553_edema
elemi7312503_elemi
eme55837183___eme
enema7612743_enema
enemy1059993_enemy
epee64628503_epe_e
exam132514623_exam_
examen1538283_examen
exams14199083_exams
exec135313943_exe_c
execs14539723_execs
exed125420593_exe_d
exempt1737453_exempt
exert124624143_exert
exes116530813_exe_s
exhume1833803_exhume
exile126117653_exile
exine125518493_exine
extreme1645653_extreme
exude134010293_exude
feeze174913823fe_eze
feme96130543__feme
femme125011433fe_mme
fleece11369903fle_ece
flexed17419093flexe_d
flexes164512953flexe_s
flexile1735073flexile
flextime2042813flextime
flexure1743413flexure
geese64316003ge_ese
gelee63626983gele_e
genome94312193genome
gleemen1035723gle_emen
heaume1137543heaume
heeze175313483he_eze
heme95034413__heme
hexade17438903hexade
hexane16379533hexane
hexed165615763hexe_d
hexer155116683hexe_r
hexerei1764163hexerei
hexers165612753hexers
hexes155123043hexe_s
hexone16289233hexone
hexose16267843hexose
ilexes134510253ilexe_s
keeve124512133ke_eve
ketene106613003ketene
kexes166216823kexe_s
lame66849293l__ame
laree56036293lare_e
laxer125420333laxe_r
laxes125430093laxe_s
laxest134913363laxest
leadmen10277903leadmen
league758743league
lease55230263le_ase
leave84723723le_ave
leben7314853lebe_n
lebens8310093lebens
lechwe1435113lechwe
ledge76519493le_dge
lee36068143l__e_e
leech104913213le_ech
leek85331733le_e_k
leeks95318893le_eks
leer46239353le_e_r
leered73816223le_ered
leers54828983le_ers
leery85919133le_ery
lees45455883le_e_s
leet45957903le_e_t
leets54927123le_ets
legate72917453legate
legend837693legend
leger65721513lege_r
legers74518313legers
leges64427293lege_s
legmen939343legmen
legumes1036633legumes
leke85527403l__eke
lemma94811033le_mma
lenes54738523lene_s
lenite6719983lenite
lense54523433le_nse
lensmen937883lensmen
leone55018823le_one
leper74820743lepe_r
lepers84817323lepers
leses54930813lese_s
lessee64116363lessee
lethe85717303le_the
leveed104111373leveed
levees93714523levees
level84116553leve_l
leveled114010383leveled
leveler10399903leveler
levels94113283levels
lever85125163leve_r
levered114212303levered
leveret103014003leveret
levers94621323levers
lex107943823lex___
lexica1536103lexica
lexis125916033lex_is
lezzie1435333lezzie
liege65314433l_iege
liegemen1144133liegemen
lieve86315473l_ieve
lime66244933l__ime
linemen938633linemen
loxed135017053loxe_d
loxes125227473loxe_s
luxate1338083luxate
luxe115222693lux__e
luxes124921503luxe_s
lycee104716743lyce_e
melee73729103mele_e
meme85330553__meme
neem67328083ne_em_
neems77316293ne_ems
neume74414403ne_ume
oedema936573oedema
oxeye1536913_oxeye
oxime1498433_oxime
peeve104915253pe_eve
pewee10319973pewe_e
plexes155313543plexe_s
raceme1039733raceme
recede95515533recede
redeem9311533redeem
redeye103811793redeye
reeve84121323re_eve
regime95313943regime
rehem103815353rehem_
rehems113410983rehems
releve95116403releve
relume8313273relume
rename82718813rename
renege72713763renege
resee54336333rese_e
resume8313783resume
retem74221953retem_
retems83914573retems
retene69224273retene
retime85321803retime
revere94621253revere
rexes124526953rexe_s
rexine134719443rexine
rheme106214053_rheme
scheme1379633scheme
secede93311993secede
seem65438563se_em_
seemed95117613se_emed
seemer84418043se_emer
seems75525023se_ems
seme65836653__seme
sememes11109203sememes
serene63522353serene
sesame8311013sesame
severe94016083severe
sexed136618543sexe_d
sexes126126223sexe_s
sleeve93411593sle_eve
taxemes1635853taxemes
teem66132603te_em_
teemed95114873te_emed
teemer85515743te_emer
teems76019783te_ems
telemen9310173telemen
telome8311923telome
tepee74724213tepe_e
terete6319333terete
theme105921733_theme
toneme8312103toneme
ulexite1445723ulexite
vegete1039483vegete
venene92912523venene
vexed165713113vexe_d
vexer155513523vexe_r
vexers165210403vexers
vexes155719123vexe_s

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.373479064.3
2DLD Change Limit1127162135.51620434.4
3Display Results2132130.0762802.6
 (SQL Overall)1786912135.96529956.6
 
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.