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

255 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
ejecting1826816(None) 
dejecting20217791dejecting
electing112113781electing
erecting112415061erecting
rejecting192211151rejecting
defecting162510222defecting
detecting13259982detecting
effecting1845582effecting
egesting1039012egesting
ejection172510042ejection
ejections18249962ejections
ejective2037152ejective
enacting11311362enacting
eructing112110172eructing
everting122213132everting
evicting1437482evicting
exacting1838522exacting
executing1945582executing
exerting162211152exerting
expecting2146692expecting
exsecting1935932exsecting
injecting1997692injecting
jesting154317712_jesting
jetting153815342_jetting
objecting2144052objecting
reejecting2045812reejecting
refecting152413352refecting
resecting122816482resecting
selecting12310532selecting
abetting1158293abetting
acting95920983__acting
advecting1645113advecting
affecting1845233affecting
agenting1039383agenting
alerting91312383alerting
averting122512733averting
beating104326873_beating
becking164416073_becking
bedecking1934283bedecking
begetting13186583begetting
belting104119133_belting
besetting12268423besetting
besting104923923_besting
betting103921403_betting
bisecting1436973bisecting
bleating113514503bleating
cementing1438763cementing
cheating144014523cheating
checking20379203checking
cleating113518133cleating
clefting14347583clefting
coacting133412703coacting
coerecting15218783coerecting
creating113921953creating
cresting114017043cresting
decking153915593_decking
decocting1538123decocting
deducting1436843deducting
defeating142311973defeating
defecating17237783defecating
deflecting1736503deflecting
dejection19178663dejection
dejections20168353dejections
deleting103314423dele_ting
dementing13311043dementing
denting94422183_denting
depicting1537813depicting
deserting11713143deserting
detesting112610323detesting
devesting14249903devesting
dieting93616833die_ting
directing1338823directing
disjecting2177243disjecting
ducting113713593_ducting
dueting93814393due_ting
duetting1047183duetting
easting84924303e_asting
eating75134403__eating
eching126315563__eching
editing9313133e_diting
educating1337933educating
educing1137683educ_ing
eject145016043eject___
ejecta15337393eject__a
ejected17297653eject_ed
ejectives2145443ejectives
ejectment2044823ejectment
ejector16378603eject_or
ejectors17328663ejectors
ejects15409953eject__s
elating83423083e_lating
election102015353election
elections112414973elections
elective13311003elective
electroing1346903electroing
elevating1338203elevating
eliciting1237773eliciting
eluting84115293e_luting
emceeing1343573emceeing
emending12298893emending
emerging1237893emerging
emetin8613463eme_tin_
emetine9712943eme_tine
emetins9812643eme_tins
emitting112410353emitting
emoting10313563e_moting
enditing10311073enditing
equating18310113equating
erectile1039513erectile
erection102115513erection
erections112515213erections
erective13311833erective
erupting11218443erupting
escoting1158713escoting
estating92614993estating
etching134511843e_tching
evection131910833evection
evections142510693evections
evening11310223eve_ning
eviting11511373e_viting
exalting1638033exalting
excepting2145873excepting
exciting1838023exciting
execrating2047883execrating
exempting2144223exempting
existing1639073existing
exiting15311393e_xiting
experting1938053experting
exserting1736663exserting
exulting1637643exulting
eyeing10429363eye__ing
faceting1438783faceting
felting113515213_felting
feting104417793_fe_ting
fetting113517873_fetting
flecking18408233flecking
fleeting122910323fleeting
fretting122711523fretting
gecking154111363_gecking
getting93316563_getting
gleeting10279173gleeting
greeting103112353greeting
guesting1058463guesting
heating114024323_heating
hefting144510913_hefting
henting113719653_henting
ideating10311703ideating
infecting15109673infecting
jacking214515263_jacking
jeeing144512143_je_eing
jeeping174010333_jeeping
jeering153513043_jeering
jelling153516613_jelling
jerking19308923_jerking
jessing153710623_jessing
jestings16368023_jestings
jettying1933953_jettying
jewing174411423_je_wing
jilting153211743_jilting
jolting153410913_jolting
jotting152912773_jotting
justing153615163_justing
jutting153313713_jutting
kecking134111883_kecking
leching134613653_leching
lectin82515013_lectin_
lectins92515003_lectins
leeching14318373leeching
letting83218533_letting
meeting103314963_meeting
melting103317753_melting
meting94320593_me_ting
mulcting13246983mulcting
necking143913893_necking
neglecting1444543neglecting
nesting84320443_nesting
netting84018763_netting
peching154513903_peching
pecking164017783_pecking
pectin102615533_pectin_
pectins112315233_pectins
pelting102917273_pelting
perfecting1847513perfecting
petting103720953_petting
piecing12410453piec_ing
pleating112916053pleating
preacting142412533preacting
prelecting15310163prelecting
projecting22177243projecting
questing1838273questing
reacting113317893reacting
reciting113118073_reciting
recking144319923_recking
redacting13612303redacting
reelecting1338783reelecting
reerecting1339973reerecting
reesting93118273reesting
reflecting1638823reflecting
reheating132314913reheating
reinjecting2144453reinjecting
rejectingly2442943rejectingly
rejection181710253rejection
rejections191510103rejections
rejective2148253rejective
relenting102716773relenting
reletting102713943reletting
relucting1239773relucting
remeeting12311433remeeting
remelting12311703remelting
renesting102514703renesting
renting84026853_renting
reobjecting2343033reobjecting
repeating122618983repeating
repenting122316553repenting
rerenting102617663rerenting
reseating102421533reseating
resenting102619293resenting
resetting102816293resetting
respecting1549883respecting
resting85031183_resting
retesting102614603retesting
retting83425883_retting
reverting132315133reverting
revesting132814123revesting
revetting132912633revetting
rewetting132710443rewetting
scenting113212813scenting
seating84130683_seating
setting83621393_setting
sheeting122712833sheeting
sleeting93114163sleeting
smelting11339713smelting
speccing15306643speccing
specking17359733specking
stetting93410713stetting
subjecting2245553subjecting
sweating123213023sweating
sweeting123911313sweeting
tenting84621153_tenting
testing86021053_testing
tincting1148883tincting
trajecting2044293trajecting
treating92519613treating
tweeting12267033tweeting
venting114218093_venting
vesting114618683_vesting
vetting114216563_vetting
weeting113816053_weeting
welting113615313_welting
westing115020273_westing
wetting114117383_wetting
whetting1535973whetting
wrecking18328153wrecking
wresting123811833wresting
zesting174515333_zesting

Search took 10 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 Filter1786911461620.796224486.2
2DLD Change Limit1461622558.50017195.5
3Display Results2552550.1102318.2
 (SQL Overall)1786912559.40618997.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.