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

155 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
ejecta1533739(None) 
dejecta17376361dejecta
eject145016041eject_
ejects15409951ejects
deject164512842deject_
dejects17389222dejects
egesta7428652egesta
ejected17297652ejected
ejector16378602ejector
elect74327032elect_
elects83315002elects
erect74129332erect_
erects84116182erects
exacta15337392exacta
recta74220262_recta
reject154116282reject_
rejects163910692rejects
tecta74215522_tecta
abject17137703abject_
aceta74017353ace_ta
acta69524803__acta
aecia73819283_aecia
areca75618633arec_a
beretta938463beretta
beta66234133_be_ta
betta74916843_betta
caeca93915133caec_a
ceca84820783_cec_a
celesta947643celesta
cementa112810533cementa
cesta75419483_cesta
cuesta838513cuesta
defect124816173defect_
defects134511523defects
dejected19307593dejected
delta66117773_delta
detect94217403detect_
detects104011093detects
dicta84915633_dicta
edema8610553ede_ma
edemata1046003edemata
edict84722283edict_
edictal1046993edictal
edicts94911703edicts
educt85017103educt_
educts9439893educts
effect1437443effect_
effects1535283effects
egest65222343egest_
egests74411253egests
ejectable20136573ejectable
ejecting18268163ejecting
ejection172510043ejection
ejective2037153ejective
ejectors17328663ejectors
elected102812613elected
electee92513243electee
elector93313253elector
electro92810033electro
emerita938713emerita
emeute838533emeute
enact73525363enact_
enacts84012973enacts
enema7612743ene_ma
enemata948013enemata
epact94921533epact_
epacts105010393epacts
erected103213993erected
erecter93113393erecter
erectly1257483erectly
erector93513803erector
erica7316543eric_a
errata639013errata
eruct74022353eruct_
eructs83610793eructs
eta35834193__e_ta
event85924443event_
events94814073events
evert84929513evert_
everts94514893everts
evict104417143evict_
evicts11368553evicts
exact143516933exact_
exactas16336433exactas
exacts15359613exacts
exec135313943exec__
execs14539723exec_s
execute1636783execute
exedra1434503exedra
exert124624143exert_
exerts133712293exerts
expect1758903expect_
expects1866883expects
exsect1558503exsect_
exsects1655573exsects
eyecup1344493eyecup
feta76528903_fe_ta
fiesta938123fiesta
geta56627443_ge_ta
inject153210233inject_
injects16257453injects
jest116738503_jest_
jests125922453_jests
jet106754823_je_t_
jete115927253_je_te
jets115834103_je_ts
jetty156212583_jetty
jota116423623_j_ota
junta123713673_junta
lepta75714393_lepta
mecca1139933_mecca
menta74424423_menta
meta65932413_me_ta
nectar838853_nectar
nepeta837893nepe_ta
object17135803object_
objects18123693objects
omenta83411723omenta
perfecta15115203perfecta
peseta8310573pese_ta
pieta75421753pie_ta
plectra1145783plectra
reata54225393_reata
rectal84418133_rectal
recti73619623_recti
recto74520803_recto
reeject16349623reeject_
reejects17336083reejects
refect114319333refect_
refects124012743refects
rejected182710113rejected
rejectee17289623rejectee
rejecter17258943rejecter
rejector17237723rejector
resect84424703resect_
resects94115593resects
sancta839833sancta
sect67443623_sect_
sects75622893_sects
select82621173select_
selects91912143selects
seneca839793senec_a
septa75518083_septa
seta45637313_se_ta
shelta93111793shelta
siesta639503siesta
spectra11275833spectra
tectal83713253_tectal
testa54822043_testa
theca103311453thec_a
theta83414573the_ta
vesta86618303_vesta
yenta83917043_yenta
zeta135121643_ze_ta
zoecia1735553zoecia

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.393454684.5
2DLD Change Limit1127161555.10622075.2
3Display Results1551550.0463369.6
 (SQL Overall)1786911555.54532225.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.