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

176 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
foveated153629(None) 
foveate1338361foveate_
caveated1439132caveated
coveted133011522cove_ted
floreated1346572floreated
foliated1249912foliated
fomented1437802fomented
foredated1447682foredated
forested12312462forested
foveae1237562fovea_e_
advected1534533advected
adverted1336103adverted
averted112211613_averted
aviated11310263_aviated
bleated104015973_bleated
bloviated1573623bloviated
boated94221973bo__ated
borated104116363bo_rated
caseated11310713caseated
cheated134416343_cheated
cleated103417843_cleated
coated94927033co__ated
cocreated142710093cocreated
coheaded1536603coheaded
collated113615063collated
combated1539823combated
convected1738783convected
convented15410753convented
converted15311563converted
corelated12411823corelated
covenanted1663803covenanted
covered133315293cove_red
coveter122912063cove_ter
created104323443_created
cuneated11310103cuneated
defeated132812163defeated
devested13239133devested
deviated13311043deviated
diverted13199583diverted
divested13268213divested
doated84118183do__ated
dogeared1145793dogeared
donated93513863do_nated
dovened12389063dove_ned
elevated12118293elevated
everted112711853_everted
faceted13509563face_ted
facetted1445743facetted
falcated1438473falcated
fated95632133f___ated
feared106320433f__eared
feased105718713f__eased
feasted11310843f__easted
feater95224053f__eater
feazed195112633f__eazed
federated1438413federated
fellated1239563fellated
felted103714653f__elted
feted94420933f__e_ted
fetted104817893f__etted
fevered14339723feve_red
figeater1236943figeater
fileted1159093file_ted
filiated12610083filiated
fixated1835533f_ixated
fleeted113310233f_leeted
floated113312703f_loated
floriated1347023floriated
foaled104515963fo__aled
foamed126014403fo__amed
foetid10510513fo_e_tid
foisted113210603fo_isted
folate93320393fo_late_
folates103218453fo_lates
foliaged1344673foliaged
foliate10513533foliate_
foliates11412753foliates
fomenter1339263fomenter
footed104418623fo__oted
foraged124812273fo_raged
forayed14368593fo_rayed
forearmed1544863forearmed
forecasted1685103forecasted
foredate12310913foredate_
foredates13310043foredates
forenamed1545163forenamed
forester11313673forester
foretasted1484753foretasted
forfeited1643793forfeited
formate123115093formate_
formates132814293formates
formatted1544883formatted
fossate10388603fossate_
fouette1038213fouette_
fouettes1137883fouettes
fovea11310483fovea___
foveal1237703fovea__l
foveas1238623fovea__s
foveolate15104293foveolate_
foveole13106873foveole_
foveoles1496643foveoles
foveolet14107543foveolet
freaked15399703f_reaked
fretted113411853f_retted
furcated1437593furcated
galeated104111573galeated
governed1335193governed
heated104525593__heated
hoveled14209293hove_led
hovelled15146843hovelled
hovered143411573hove_red
ideated9310973_ideated
invected14258873invected
invented122510663invented
inverted122312163inverted
invested12229693invested
iodated9310023io_dated
lineated9711063lineated
lobated102610943lo_bated
located103114183lo_cated
meated94222403__meated
moated94819003mo__ated
moderated1388143moderated
molested11178243molested
nonrated9310843nonrated
nonvested1346003nonvested
notated82713663no_tated
obverted1435103obverted
obviated1444563obviated
oleate6318883_oleate_
oleates7417833_oleates
operated11512223_operated
opiated1039483_opiated
orated74221503_o_rated
ovate84214393_ov_ate_
overacted1539633_overacted
overaged13511673_overaged
overate10620963_overate_
overawed1579963_overawed
overbed132811843_overbed
overed102216623_ove_red
overfed142510253_overfed
overhated16610443_overhated
overrated13313073_overrated
ovulated1237083_ovulated
pileated112711133pileated
pleated103816633_pleated
poleaxed1854813poleaxed
reheated122415003reheated
repeated113117443repeated
reseated93220263reseated
revealed123211213revealed
reverted122714713reverted
revested122612243revested
revetted122210943revetted
riveted11258573rive_ted
rivetted12226083rivetted
roseate7613453roseate_
rotated82715293ro_tated
seated75131053__seated
solated83618023so_lated
solvated12237443solvated
sweated113411543_sweated
teated74924023__teated
threated1259203threated
togated94410663to_gated
tolerated1049123tolerated
treated83618703_treated
unheated121514553unheated
unseated91317683unseated
unvested122210223unvested
vealed103916323__vealed
vented104617923__vented
vested104217353__vested
vetted104316323__vetted
zonated173310533zo_nated

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.1561145455.1
2DLD Change Limit1461621768.26617682.3
3Display Results1761760.0762315.8
 (SQL Overall)1786911768.49821027.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.