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

248 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
selected115978(None) 
elected102812611_elected
selectee10910491selectee
defected15289972defected
deflected1635982deflected
dejected19307592dejected
deleted93314912dele_ted
deselected1444082deselected
detected12289732detected
ejected17297652_ejected
electee92513242_electee
erected103213992_erected
neglected1354692neglected
prelected1439132prelected
reelected1238312reelected
refected142311662refected
reflected1547982reflected
rejected182710112rejected
relented92614942relented
relucted1138652relucted
resected112514742resected
reselected1345632reselected
select82621172select__
selectees1147012selectees
selectly1346562selectly
selectmen1344612selectmen
selector1048612selector
selects91912142select_s
sklented1335052sklented
sleeted83113222s_leeted
unelected1237822unelected
unselected1344972unselected
advected1534533advected
affected1744793affected
alerted82512223_alerted
bedecked1874573bedecked
beflecked2142653beflecked
belaced124112153belac_ed
belated103520013bel_ated
belched154011843bel_ched
beleaped1336103beleaped
belted94020633bel__ted
bisected1336203bisected
bleated104015973_bleated
celeste949653celeste_
celestes10310013celestes
cemented1338373cemented
cleated103417843_cleated
clefted13326753_clefted
coerected1447643coerected
collected1447973collected
decocted1437683decocted
deducted1356243deducted
defeated132812163defeated
defecated1637493defecated
delated93722873del_ated
deleaded1148333deleaded
deleaved1346573deleaved
delectated1446723delectated
delegated1238373delegated
delete73620703dele_te_
deletes83117933dele_tes
delisted10310563delisted
demented12311273demented
depicted1437743depicted
depleted12258723deple_ted
deserted101012203deserted
detecter11298733detecter
detested10279623detested
devested13239133devested
directed1238233directed
effected1744993effected
egested938123_egested
elated74725823_el_ated
elect74327033_elect__
electees10238723_electees
elector93313253_elector
electret10411993_electret
electro92810033_electro
electroed1246973_electroed
elects83315003_elect_s
elevated12118293_elevated
elicited1139093_elicited
eluted74915263_el_uted
enacted10310643_enacted
erecter93113393_erecter
eructed10228653_eructed
everted112711853_everted
evicted1337243_evicted
exacted1737303_exacted
executed1835503_executed
exerted152210053_exerted
expected2036743expected
exsected1835673exsected
eyeletted1342863eyeletted
fellated1239563fellated
felted103714653fel__ted
fileted1159093file_ted
flecked17358073_flecked
fleeced13358153fleec_ed
fleeched17345823fleeched
fleeted113310233_fleeted
galeated104111573galeated
gelated93615633gel_ated
gleeted9379323_gleeted
helmeted1435833helmeted
infected14229403infected
inflected1546053inflected
injected18226753injected
invected14258883invected
isleted837523isle_ted
leched123716003__leched
leeched13369503le_eched
letted74118543__letted
melted94219063mel__ted
molested11178243molested
mulcted12296693mul_cted
neglecter1263633neglecter
nonelected1355693nonelected
nonselected1454383nonselected
objected2043493objected
obtected1344553obtected
pelleted1138203pelleted
pelted94617763pel__ted
perfected1736643perfected
pileated112711133pileated
pleated103816633_pleated
praelected1544393praelected
preelected1545783preelected
preselected1643963preselected
reacted103015713re_acted
redacted12410243redacted
reejected1955093reejected
reerected1238613reerected
reested82916233re_ested
reheated122415003reheated
rejectee17289623rejectee
rejecter17258943rejecter
relaced103517213relac_ed
related83327573rel_ated
released9310243released
relegated1139763relegated
reletter81311023reletter
relisted9312623relisted
relocated12710813relocated
relocked15217743relocked
remelted11310153remelted
renested92212953renested
repeated113117443repeated
repented112614983repented
rerented92516163rerented
reseated93220263reseated
resented92716963resented
respected1438493respected
retested92212533retested
reverted122714713reverted
revested122612243revested
revetted122210943revetted
rewetted12228353rewetted
salted74121203sal__ted
saluted84511713sal_uted
scented102811883s_cented
sealifted1344573sealifted
searched14209253searched
seated75131063s__eated
seceded11319203sece_ded
secerned1136103secerned
secreted1138633secreted
sedated93714353se_dated
seduced1186753seduc_ed
seedbed11246613se_edbed
seeded84520463se_e_ded
seeled73922093se_e_led
seemed95117613se_e_med
seeped94317523se_e_ped
seethed113410193se_ethed
segmented1345063segmented
selecting12310533selecting
selection11311273selection
selective1449523selective
selectman1343553selectman
selectness1245453selectness
selectors1148963selectors
selenate81712523selenate_
selenates91611353selenates
selenide9158863selenide
selenite81713103selenite_
selenites91312083selenites
selfed10310913sel__fed
selvaged1334343selvaged
selvedged1541543selvedged
semester1038903semester
sensated938193sensated
seriated92717023seriated
serrated92513433serrated
severed113513863seve_red
sewered112911243sewe_red
sheeted113813043s_heeted
shlepped1633643shlepped
silenced1136273silenced
silenter838873silenter
silted74020013sil__ted
slacked143815453s_lacked
slanted83514743s_lanted
slated75028313s_l_ated
slatted84015183s_latted
sleaved113611133s_leaved
sledded10378873s_ledded
sledged103610333s_ledged
sleeked123510883s_leeked
sleeved11419913s_leeved
sleuthed1233813s_leuthed
slewed104815523s_le_wed
sliced94416313s_lic_ed
slicked144413843s_licked
slitted83513313s_litted
slotted84613883s_lotted
smelted10399093s_melted
solaced102911063solac_ed
solated83618023sol_ated
solecised1285873solecised
solecized2186583solecized
solicited1247973solicited
solvated12237443solvated
specced14266703s_pecced
specked16329013s_pecked
specter113111733s_pecter
splatted11356743splatted
spliced124310593splic_ed
splinted11369253splinted
stellated1046803stellated
stetted82610403s_tetted
subjected2144773subjected
sulcated11310373sulcated
sulfated1238833sulfated
suspected1444383suspected
sweated113411543s_weated
talented938423talented
telecasted1343943telecasted
telexed1536323tele_xed
telneted935073telneted
telnetted1043813telnetted
unletted9310313unletted
valeted1139013vale_ted
velveted1533833velveted
weeted103913793we_e_ted
welched16298833wel_ched
welted103715823wel__ted

Search took 9 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.423422437.4
2DLD Change Limit1461622487.92018454.8
3Display Results2482480.1102254.5
 (SQL Overall)1786912488.45321139.4
 
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.