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

175 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
oriented93748(None) 
orienter838311orienter
friended1335032friended
orient6322532orient__
oriental848482oriental
orientated1144852orientated
orienteer943212orienteer
orienters937612orienters
orients7311582orient_s
priested1138392priested
printed104016372pri_nted
rented74426592_r_ented
reoriented1145342reoriented
tormented1245962tormented
trientes82812122trientes
absented1156613absented
accented13107773accented
agented939423_agented
alienated1047743alienated
aliened81011743alien_ed
alimented1245313alimented
ariette7312373ariette_
ariettes8411353ariettes
arointed939003arointed
aroynted1244523aroynted
arrested939153arrested
assented957513assented
briefed1335743brie_fed
brinded115112053bri_nded
brined95118413bri_n_ed
cemented1338373cemented
commented16129613commented
consented12311943consented
contented12313043contented
convented15410753convented
coroneted12278323coroneted
corrected1438113corrected
corseted11311473corse_ted
created104323453cr_eated
crenated113013913cr_enated
crested103416533cr_ested
cringed113312403cri_nged
demented12311273demented
dented84120513__dented
dieted83115493_die_ted
dinted84419843_di_nted
directed1238233directed
disoriented1355263disoriented
drifted12367953dri_fted
erected103213993er_ected
fainted114211723fai_nted
feinted11379623fei_nted
fermented1546623fermented
flinted114411893fli_nted
fomented1437803fomented
forested12312463for_ested
forfeited1643793forfeited
forfended1743743forfended
fretted113411853fr_etted
friend10388933frien__d
frighted1657173frighted
fringed123611523fri_nged
fritted113611333fri_tted
fronted114011273fr_onted
garmented1345883garmented
glinted9399373gli_nted
gorgeted1135353gorge_ted
granted94715103gr_anted
greened93111263green_ed
greeted93111383gr_eeted
grieved1235283grie_ved
grifted12379583gri_fted
grinded104210633gri_nded
grinned9378553gri_nned
gritted94110903gri_tted
grunted9339283gr_unted
hented104218753__hented
hinted104318323_hi_nted
incented112412543incented
indented101811733indented
invented122510663invented
jointed15378503joi_nted
lamented1138193lamented
linted74021823_li_nted
loricated1247893loricated
margented1346813margented
minted94220583_mi_nted
misoriented1453943misoriented
mordanted1344413mordanted
objected2043493objected
obtected1344553obtected
obtested1135453obtested
obverted1435103obverted
offended1643653offended
oinked114213283o_i_nked
omened93711003o_men_ed
omitted10347893omi_tted
opened94311863o_pen_ed
opiated1039483opi_ated
opined95113853opi_n_ed
orated74221503or__ated
orbited1037733or_bited
ordered9108533orde_red
oribatid1145463oribatid
orientals946903orientals
orientate946513orientate
orientates1046043orientates
orienteers1042693orienteers
orienting1038723orienting
originated1244813originated
ornamented1342953ornamented
osiered837123osie_red
oxidated1745033oxidated
painted104214633pai_nted
parented11912213parented
patented1188893patented
pointed103813983poi_nted
portended1345643portended
precented14310693precented
preened103214993preen_ed
presented12311633presented
prevented1539003prevented
prinked143412163pri_nked
printer93917303pri_nter
quieted17309723quie_ted
ranted74324703_r_anted
reenter73217793_reenter
reested82916233_reested
reined74425523_rein_ed
reinked1239793_reinked
reinter73116843_reinter
relented92614943relented
rended84524103_r_ended
rente54733783_r_ente_
renter64527413_r_enter
rentes65431193_r_entes
repented112614983repented
rerented92516163rerented
resented92716963resented
rested74430783_r_ested
retted74826313_r_etted
rifted104115313_ri_fted
righted122912143_righted
rinded84418983_ri_nded
ringed84623843_ri_nged
rinsed75016353_ri_nsed
rioted73416373_ri_oted
ripened1038203_ripen_ed
riveted11258573_riveted
rivetted12226093_rivetted
sainted84114243sai_nted
scented102811883_scented
sklented1335053sklented
sprinted113411163spri_nted
stinted82914193sti_nted
tainted83512423tai_nted
talented938423talented
tented74221003__tented
tinted74419533_ti_nted
tormenter1146703tormenter
treated83618703tr_eated
trended94011763tr_ended
triene64316383trien_e_
trienes74118413trien_es
trined74920713tri_n_ed
trisected1244913trisected
truanted935373truanted
undented102313953undented
unrented92413923unrented
untented92613413untented
urinated9311613urinated
vented104617923__vented
worsened1236053worsen_ed
wrested113410933wr_ested
wringed123710193wri_nged

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.436409841.7
2DLD Change Limit1461621757.83018666.9
3Display Results1751750.0802187.5
 (SQL Overall)1786911758.34621410.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.